/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : 192.168.1.78
 Source Database       : jh

 Target Server Type    : MySQL
 Target Server Version : 50719
 File Encoding         : utf-8

 Date: 03/01/2018 17:06:26 PM
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `tb_action_log`
-- ----------------------------
DROP TABLE IF EXISTS `tb_action_log`;
CREATE TABLE `tb_action_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `action_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '行为id',
  `action_name` varchar(50) DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行用户id',
  `action_ip` bigint(20) NOT NULL COMMENT '执行行为者ip',
  `model` varchar(50) NOT NULL DEFAULT '' COMMENT '触发行为的表',
  `record_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '触发行为的数据id',
  `remark` varchar(255) NOT NULL DEFAULT '' COMMENT '日志备注',
  `status` tinyint(2) NOT NULL DEFAULT '1' COMMENT '状态',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '执行行为的时间',
  PRIMARY KEY (`id`),
  KEY `action_ip_ix` (`action_ip`),
  KEY `action_id_ix` (`action_id`),
  KEY `user_id_ix` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='行为日志表';

-- ----------------------------
--  Records of `tb_action_log`
-- ----------------------------
BEGIN;
INSERT INTO `tb_action_log` VALUES ('1', '0', '管理员登入', '1', '3232235530', 'Member', '0', '用户:admin12登入后台。', '1', '1473709579'), ('2', '0', '管理员登入', '1', '3232235786', 'Member', '0', '用户:admin12登入后台。', '1', '1473730015'), ('3', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1475995248'), ('4', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1476949387'), ('5', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1478673885'), ('6', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1479195786'), ('7', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1479202928'), ('8', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1480298194'), ('9', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1480298297'), ('10', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1480381515'), ('11', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1480467517'), ('12', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1480555879'), ('13', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1480908149'), ('14', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1481245314'), ('15', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1481245492'), ('16', '0', '管理员登入', '2', '2130706433', 'Member', '0', '用户:test登入后台。', '1', '1481245766'), ('17', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1481245860'), ('18', '0', '管理员登入', '2', '2130706433', 'Member', '0', '用户:test登入后台。', '1', '1481245943'), ('19', '0', '管理员登入', '2', '2130706433', 'Member', '0', '用户:test登入后台。', '1', '1481245979'), ('20', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1481249893'), ('21', '0', '管理员登入', '1', '3232235786', 'Member', '0', '用户:admin12登入后台。', '1', '1500969324'), ('22', '0', '管理员登入', '1', '3232235786', 'Member', '0', '用户:admin12登入后台。', '1', '1501054317'), ('23', '0', '管理员登入', '1', '1033094521', 'Member', '0', '用户:admin12登入后台。', '1', '1501058640'), ('24', '0', '管理员登入', '1', '1033094521', 'Member', '0', '用户:admin12登入后台。', '1', '1501063062'), ('25', '0', '管理员登入', '1', '1033094521', 'Member', '0', '用户:admin12登入后台。', '1', '1501118364'), ('26', '0', '管理员登入', '1', '3232235786', 'Member', '0', '用户:admin12登入后台。', '1', '1501119071'), ('27', '0', '管理员登入', '1', '3232235786', 'Member', '0', '用户:admin12登入后台。', '1', '1501553167'), ('28', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1513583510'), ('29', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1513598823'), ('30', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1513599239'), ('31', '0', '管理员登入', '1', '3232235828', 'Member', '0', '用户:admin12登入后台。', '1', '1513608463'), ('32', '0', '管理员登入', '1', '3232235828', 'Member', '0', '用户:admin12登入后台。', '1', '1513651723'), ('33', '0', '管理员登入', '1', '1942381418', 'Member', '0', '用户:admin12登入后台。', '1', '1513664586'), ('34', '0', '管理员登入', '1', '1942381418', 'Member', '0', '用户:admin12登入后台。', '1', '1513665307'), ('35', '0', '管理员登入', '1', '3232235854', 'Member', '0', '用户:admin12登入后台。', '1', '1513665609'), ('36', '0', '管理员登入', '1', '1942381418', 'Member', '0', '用户:admin12登入后台。', '1', '1513681221'), ('37', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1513690573'), ('38', '0', '管理员登入', '1', '1942381418', 'Member', '0', '用户:admin12登入后台。', '1', '1513731835'), ('39', '0', '管理员登入', '1', '3232235828', 'Member', '0', '用户:admin12登入后台。', '1', '1513732774'), ('40', '0', '管理员登入', '1', '1942381418', 'Member', '0', '用户:admin12登入后台。', '1', '1513739668'), ('41', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1513756879'), ('42', '0', '管理员登入', '1', '1942381418', 'Member', '0', '用户:admin12登入后台。', '1', '1513766616'), ('43', '0', '管理员登入', '1', '3232235828', 'Member', '0', '用户:admin12登入后台。', '1', '1513774206'), ('44', '0', '管理员登入', '1', '3232235828', 'Member', '0', '用户:admin12登入后台。', '1', '1513774208'), ('45', '0', '管理员登入', '1', '3232235828', 'Member', '0', '用户:admin12登入后台。', '1', '1513826682'), ('46', '0', '管理员登入', '1', '3232235892', 'Member', '0', '用户:admin12登入后台。', '1', '1513826728'), ('47', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1514277399'), ('48', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1514424271'), ('49', '0', '管理员登入', '1', '3232235828', 'Member', '0', '用户:admin12登入后台。', '1', '1514428687'), ('50', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1514440382'), ('51', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1514444577'), ('52', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1514450360'), ('53', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1514517675'), ('54', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1514869847'), ('55', '0', '管理员登入', '1', '3232236021', 'Member', '0', '用户:admin12登入后台。', '1', '1514869900'), ('56', '0', '管理员登入', '1', '3232236008', 'Member', '0', '用户:admin12登入后台。', '1', '1516261401'), ('57', '0', '管理员登入', '1', '2130706433', 'Member', '0', '用户:admin12登入后台。', '1', '1517534667'), ('58', '0', '管理员登入', '1', '3232235854', 'Member', '0', '用户:admin12登入后台。', '1', '1517534903'), ('59', '0', '管理员登入', '1', '1942259337', 'Member', '0', '用户:admin12登入后台。', '1', '1517804132'), ('60', '0', '管理员登入', '1', '1942259337', 'Member', '0', '用户:admin12登入后台。', '1', '1517815235'), ('61', '0', '管理员登入', '1', '1942259337', 'Member', '0', '用户:admin12登入后台。', '1', '1517985281'), ('62', '0', '管理员登入', '1', '1942259337', 'Member', '0', '用户:admin12登入后台。', '1', '1517985627'), ('63', '0', '管理员登入', '1', '3232235854', 'Member', '0', '用户:admin12登入后台。', '1', '1519261414'), ('64', '0', '管理员登入', '1', '3232235854', 'Member', '0', '用户:admin12登入后台。', '1', '1519263711'), ('65', '0', '管理员登入', '1', '3232235854', 'Member', '0', '用户:admin12登入后台。', '1', '1519268841'), ('66', '0', '管理员登入', '1', '1942378971', 'Member', '0', '用户:admin12登入后台。', '1', '1519347947'), ('67', '0', '管理员登入', '1', '605614526', 'Member', '0', '用户:admin12登入后台。', '1', '1519636040'), ('68', '0', '管理员登入', '1', '605614526', 'Member', '0', '用户:admin12登入后台。', '1', '1519636168'), ('69', '0', '管理员登入', '1', '3232235798', 'Member', '0', '用户:admin12登入后台。', '1', '1519718224'), ('70', '0', '管理员登入', '1', '3232235833', 'Member', '0', '用户:admin12登入后台。', '1', '1519804412'), ('71', '0', '管理员登入', '1', '3232235832', 'Member', '0', '用户:admin12登入后台。', '1', '1519804583'), ('72', '0', '管理员登入', '1', '1942914858', 'Member', '0', '用户:admin12登入后台。', '1', '1519870198');
COMMIT;

-- ----------------------------
--  Table structure for `tb_activity`
-- ----------------------------
DROP TABLE IF EXISTS `tb_activity`;
CREATE TABLE `tb_activity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(255) DEFAULT NULL COMMENT '活动种类',
  `name` varchar(255) DEFAULT NULL COMMENT '活动名字',
  `share_title` varchar(255) DEFAULT NULL COMMENT '分析标题',
  `create_time` int(11) DEFAULT NULL,
  `start_time` int(11) DEFAULT NULL COMMENT '活动开始时间',
  `end_time` varchar(11) DEFAULT NULL COMMENT '活动结束时间',
  `front_cover` varchar(255) DEFAULT NULL COMMENT '封面',
  `activity_number` varchar(4) DEFAULT NULL COMMENT '报名活动最大人数（ 1 数量 2 不限）',
  `remark` varchar(255) DEFAULT NULL COMMENT '人数备注',
  `meeting_place` varchar(255) DEFAULT NULL COMMENT '集合地点',
  `destination_place` varchar(255) DEFAULT NULL COMMENT '目的地点',
  `activity_description` text COMMENT '活动介绍',
  `registration_required` text COMMENT '报名须知',
  `reply` varchar(255) DEFAULT NULL COMMENT '取消活动的备注',
  `status` tinyint(4) DEFAULT '1' COMMENT '-1 删除   0.取消活动   1 预报名中 2活动开始.  ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COMMENT='活动报名';

-- ----------------------------
--  Records of `tb_activity`
-- ----------------------------
BEGIN;
INSERT INTO `tb_activity` VALUES ('1', '[{\"typeid\":\"1\",\"name\":\"\\u8001\\u75f0\\u9178\\u83dc\\u9762\",\"number\":\"1\",\"price\":\"100\"},{\"typeid\":\"2\",\"name\":\"\\u4e00\\u6876\\u725b\\u8089\\u9762\",\"number\":\"2\",\"price\":\"200\"}]', '多吃方便面', null, null, '1514649600', null, '/uploads/picture/20171219\\6ca6a021a0683e5fccd153afa0a1fb95.JPG', '12', null, '东北', '杭州', '风格结合的乳房也不如他的身体日公布的消防设备供货商', '按时到该发生的发的说法都十分的广泛和高科技也会加快人体', '11', '2'), ('2', '[{\"typeid\":\"1\",\"name\":\"\\u4e00\\u5bb6\\u95e8\",\"number\":\"3111\",\"price\":\"10\"},{\"typeid\":\"2\",\"name\":\"\\u4eb2\\u5b50\",\"number\":\"2\",\"price\":\"90\"}]', '完蛋', null, null, '1503936000', null, '/uploads/picture/20171213/c018b668fad627256af9bcb0f422392e.jpg', '', null, '东北', 'aa', '<section class=\"info\" style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, &quot;Microsoft YaHei&quot;, 微软雅黑, STHeiti, &quot;WenQuanYi Micro Hei&quot;, SimSun, Arial, Helvetica, sans-serif; font-size: 12px;\"><h1 class=\"title\" style=\"margin-top: 0px; margin-bottom: 0px; font-size: 26px; line-height: 1.5em; color: rgb(51, 51, 51); padding: 28px 25px 0px;\">水滴直播关闭，周鸿祎哑火之外的伤害还有哪些？</h1><div class=\"other-info\" style=\"margin: 25px 25px 0px; border-bottom: 1px solid rgb(234, 234, 234); padding-bottom: 25px;\"><span class=\"author\" style=\"font-size: 16px; padding-right: 20px;\"><a href=\"https://baijia.baidu.com/u?app_id=1536766600598965&amp;wfr=pc&amp;fr=new_dtl\" target=\"_blank\" style=\"color: rgb(51, 51, 51); outline: 0px;\">百略网</a></span>&nbsp;<span class=\"time\" style=\"font-size: 16px; color: rgb(153, 153, 153); padding: 0px 20px; border-left: 1px solid rgb(51, 51, 51);\">2017-12-20 12:35</span>&nbsp;<span class=\"data\" style=\"font-size: 16px; color: rgb(153, 153, 153); padding: 0px 20px; border-left: 1px solid rgb(51, 51, 51);\">阅读：4572</span></div></section><section class=\"news-content\" style=\"padding: 25px; font-size: 16px; line-height: 2; text-align: justify; word-wrap: break-word; word-break: break-all; color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, &quot;Microsoft YaHei&quot;, 微软雅黑, STHeiti, &quot;WenQuanYi Micro Hei&quot;, SimSun, Arial, Helvetica, sans-serif;\"><div class=\"abstract\" style=\"color: rgb(153, 153, 153); margin-bottom: 30px;\">摘要：今日早间，360水滴直播官方宣布关闭公告，随后，还发布名为《水滴直播产品经理的反思》一文，阐述水滴直播的出发点和犯下的错误。闹的沸沸扬扬的「周叔叔」事件，最终以360方面的全面撤退画上句号。12月12</div><p style=\"margin-top: 10px;\">今日早间，360水滴直播官方宣布关闭公告，随后，还发布名为《水滴直播产品经理的反思》一文，阐述水滴直播的出发点和犯下的错误。</p><p style=\"margin-top: 10px;\"><br></p><p data-bjh-caption-id=\"cap-91322616\" style=\"margin-top: 10px;\"><img data-w=\"683\" src=\"https://timg01.bdimg.com/timg?pacompress&amp;imgtype=1&amp;sec=1439619614&amp;autorotate=1&amp;di=40b30f8f165615245d73c814684ef57e&amp;quality=90&amp;size=b870_10000&amp;src=http%3A%2F%2Fboscdn.bpc.baidu.com%2Fv1%2Fmediaspot%2F9c809ed3b53fc505cde36103face1b81.jpeg\" class=\"\" data-h=\"716\" style=\"max-width: 90%; display: block; margin: 20px auto;\"></p><p style=\"margin-top: 10px;\">闹的沸沸扬扬的「周叔叔」事件，最终以360方面的全面撤退画上句号。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">12月12日，陈菲菲在自媒体中发文质疑360水滴直播侵犯用户隐私，并称周鸿祎为「周叔叔」；</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">12月13日，周鸿祎通过自媒体炮轰陈菲菲是黑公关，背后有人操控；</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">当天，陈菲菲回应周鸿祎，声称自己是个人行为，公众的讨论是民意对周鸿祎的讨伐；周鸿祎则在微博上转发自己的专访文章，并用不小的篇幅质疑有利益相关人造谣360；</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">随后几天，关于水滴直播侵犯隐私乃至涉及色情直播的消息纷至沓来，将水滴直播，360，以及周鸿祎带入了舆论漩涡之中。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">始终认为「周叔叔」事件背后必然有人指使的周鸿祎，到最后也没有找到他眼中的凶手，在各方压力下，红衣大炮最终哑了火，以偃旗息鼓，全面关闭水滴直播的方式，结束了这场战争。</p><p style=\"margin-top: 10px;\"><br></p><p data-bjh-caption-id=\"cap-85172679\" style=\"margin-top: 10px;\"><img data-w=\"544\" src=\"https://timg01.bdimg.com/timg?pacompress&amp;imgtype=1&amp;sec=1439619614&amp;autorotate=1&amp;di=26f6ebb9180842b0dab32f37294b6519&amp;quality=90&amp;size=b870_10000&amp;src=http%3A%2F%2Fboscdn.bpc.baidu.com%2Fv1%2Fmediaspot%2F549b8fa59095a87bb2432560a99c143a.jpeg\" class=\"\" data-h=\"360\" style=\"max-width: 90%; display: block; margin: 20px auto;\"></p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\"><span style=\"font-weight: 700;\">不得不战败退场的周鸿祎</span></p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">一直号称「红衣大炮」的周鸿祎，尽管在此次事件中重燃炮火，且发动了一如既往的猛烈攻击，但是最终的失败却实属必然。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">首先，当涉及公共隐私、偷拍、直播这一系列敏感字眼被抛至大众眼前时，作为矛头指向的唯一责任人，无论事实真相如何，都必然会导致责任方受到巨大的舆论压力。水滴直播的产品经理在反思中，用「百口莫辩」阐述自己的无奈，也实在准确。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">但是，这并不意味着水滴直播是大众舆论下的错杀。作为直播硬件和直播平台的提供方，360在无法用技术或是人工，对于产品使用者进行监管或是干预，本身就是360本身应当承担的责任范围。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">同时，黑客通过技术漏洞攻破360摄像头，从而获取个人隐私直播画面，这样严重状况的出现，以网络安全为核心业务的360更是难辞其咎。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">360自称以「用户至上」为企业文化，那么，当用户行为威胁了公共隐私，甚至当用户因为产品缺陷而遭受隐私伤害时，360无论付出多大代价，都应当承担起责任。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">其次，此次事件所形成的舆论危机，给不了360太多挣扎的机会。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">在360回归A股上市之后，周鸿祎的言行显然收敛了许多。乌镇互联网大会上，还与马化腾、傅盛等昔日对手坐到了同一个饭桌上，友好的局面，显然是为了给360的顺利发展进行舆论铺垫。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">然而，水滴直播的负面舆论不仅打破了周鸿祎努力营造的友好局面，其负面影响力也超越了周鸿祎的预料，成为他无法抗争的困局。更可怕的是，这一次周鸿祎连对手都找不到，尽管他一再指责陈菲菲是黑公关，但是也不过是诛心之论，并没有找到证据。点燃大炮的周鸿祎，却始终难以找到一个明确的目标。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">这样的局面，是周鸿祎无法破解的。负面舆论的持续发酵，必然会导致360的公关形象不断跌落，关闭水滴直播，可以将其视作「断臂自保」的必然动作。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\"><span style=\"font-weight: 700;\">关闭水滴直播，对360的影响有多大？</span></p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">尽管当前水滴直播对于360来说并非核心业务，但是关闭水滴直播，对360的负面影响却并不小。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">自2011年后，移动互联网的大潮，让360不得不面对转型的巨大挑战。以免费杀毒软件起家的360，早年成功占据了 PC 市场，但是面对移动互联网，360的优势正在衰减。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">在移动互联网的探索中，手机和直播，是360最明显的动作。然而，手机业务却错失了风口，360手机面对华为小米和 OV，几乎没有挑战成功的可能，百万级的销量，也无法支撑360对于移动互联网的战略布局。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">可直播业务同样不好过。2015年6月，360上线花椒直播，同年8月份，水滴直播上线。经过2年多的运营，时至今日，花椒直播仍旧没有找到足以支撑战略的盈利模式，周鸿祎对于直播、游戏以及社交方面的认知短板，也导致了他在直播平台的发展上找不到方向。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">而水滴直播，相比花椒存在感更加薄弱，不仅不赚钱，也没有什么影响力。但是，周鸿祎并不愿意抛弃这个「拖油瓶」，如今断然抛弃，也是面对舆论危机的无奈之举。</p></section>', '<section class=\"info\" style=\"color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, &quot;Microsoft YaHei&quot;, 微软雅黑, STHeiti, &quot;WenQuanYi Micro Hei&quot;, SimSun, Arial, Helvetica, sans-serif; font-size: 12px;\"><h1 class=\"title\" style=\"margin-top: 0px; margin-bottom: 0px; font-size: 26px; line-height: 1.5em; color: rgb(51, 51, 51); padding: 28px 25px 0px;\">水滴直播关闭，周鸿祎哑火之外的伤害还有哪些？</h1><div class=\"other-info\" style=\"margin: 25px 25px 0px; border-bottom: 1px solid rgb(234, 234, 234); padding-bottom: 25px;\"><span class=\"author\" style=\"font-size: 16px; padding-right: 20px;\"><a href=\"https://baijia.baidu.com/u?app_id=1536766600598965&amp;wfr=pc&amp;fr=new_dtl\" target=\"_blank\" style=\"color: rgb(51, 51, 51); outline: 0px;\">百略网</a></span>&nbsp;<span class=\"time\" style=\"font-size: 16px; color: rgb(153, 153, 153); padding: 0px 20px; border-left: 1px solid rgb(51, 51, 51);\">2017-12-20 12:35</span>&nbsp;<span class=\"data\" style=\"font-size: 16px; color: rgb(153, 153, 153); padding: 0px 20px; border-left: 1px solid rgb(51, 51, 51);\">阅读：4572</span></div></section><section class=\"news-content\" style=\"padding: 25px; font-size: 16px; line-height: 2; text-align: justify; word-wrap: break-word; word-break: break-all; color: rgb(51, 51, 51); font-family: &quot;Helvetica Neue&quot;, &quot;Microsoft YaHei&quot;, 微软雅黑, STHeiti, &quot;WenQuanYi Micro Hei&quot;, SimSun, Arial, Helvetica, sans-serif;\"><div class=\"abstract\" style=\"color: rgb(153, 153, 153); margin-bottom: 30px;\">摘要：今日早间，360水滴直播官方宣布关闭公告，随后，还发布名为《水滴直播产品经理的反思》一文，阐述水滴直播的出发点和犯下的错误。闹的沸沸扬扬的「周叔叔」事件，最终以360方面的全面撤退画上句号。12月12</div><p style=\"margin-top: 10px;\">今日早间，360水滴直播官方宣布关闭公告，随后，还发布名为《水滴直播产品经理的反思》一文，阐述水滴直播的出发点和犯下的错误。</p><p style=\"margin-top: 10px;\"><br></p><p data-bjh-caption-id=\"cap-91322616\" style=\"margin-top: 10px;\"><img data-w=\"683\" src=\"https://timg01.bdimg.com/timg?pacompress&amp;imgtype=1&amp;sec=1439619614&amp;autorotate=1&amp;di=40b30f8f165615245d73c814684ef57e&amp;quality=90&amp;size=b870_10000&amp;src=http%3A%2F%2Fboscdn.bpc.baidu.com%2Fv1%2Fmediaspot%2F9c809ed3b53fc505cde36103face1b81.jpeg\" class=\"\" data-h=\"716\" style=\"max-width: 90%; display: block; margin: 20px auto;\"></p><p style=\"margin-top: 10px;\">闹的沸沸扬扬的「周叔叔」事件，最终以360方面的全面撤退画上句号。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">12月12日，陈菲菲在自媒体中发文质疑360水滴直播侵犯用户隐私，并称周鸿祎为「周叔叔」；</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">12月13日，周鸿祎通过自媒体炮轰陈菲菲是黑公关，背后有人操控；</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">当天，陈菲菲回应周鸿祎，声称自己是个人行为，公众的讨论是民意对周鸿祎的讨伐；周鸿祎则在微博上转发自己的专访文章，并用不小的篇幅质疑有利益相关人造谣360；</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">随后几天，关于水滴直播侵犯隐私乃至涉及色情直播的消息纷至沓来，将水滴直播，360，以及周鸿祎带入了舆论漩涡之中。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">始终认为「周叔叔」事件背后必然有人指使的周鸿祎，到最后也没有找到他眼中的凶手，在各方压力下，红衣大炮最终哑了火，以偃旗息鼓，全面关闭水滴直播的方式，结束了这场战争。</p><p style=\"margin-top: 10px;\"><br></p><p data-bjh-caption-id=\"cap-85172679\" style=\"margin-top: 10px;\"><img data-w=\"544\" src=\"https://timg01.bdimg.com/timg?pacompress&amp;imgtype=1&amp;sec=1439619614&amp;autorotate=1&amp;di=26f6ebb9180842b0dab32f37294b6519&amp;quality=90&amp;size=b870_10000&amp;src=http%3A%2F%2Fboscdn.bpc.baidu.com%2Fv1%2Fmediaspot%2F549b8fa59095a87bb2432560a99c143a.jpeg\" class=\"\" data-h=\"360\" style=\"max-width: 90%; display: block; margin: 20px auto;\"></p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\"><span style=\"font-weight: 700;\">不得不战败退场的周鸿祎</span></p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">一直号称「红衣大炮」的周鸿祎，尽管在此次事件中重燃炮火，且发动了一如既往的猛烈攻击，但是最终的失败却实属必然。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">首先，当涉及公共隐私、偷拍、直播这一系列敏感字眼被抛至大众眼前时，作为矛头指向的唯一责任人，无论事实真相如何，都必然会导致责任方受到巨大的舆论压力。水滴直播的产品经理在反思中，用「百口莫辩」阐述自己的无奈，也实在准确。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">但是，这并不意味着水滴直播是大众舆论下的错杀。作为直播硬件和直播平台的提供方，360在无法用技术或是人工，对于产品使用者进行监管或是干预，本身就是360本身应当承担的责任范围。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">同时，黑客通过技术漏洞攻破360摄像头，从而获取个人隐私直播画面，这样严重状况的出现，以网络安全为核心业务的360更是难辞其咎。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">360自称以「用户至上」为企业文化，那么，当用户行为威胁了公共隐私，甚至当用户因为产品缺陷而遭受隐私伤害时，360无论付出多大代价，都应当承担起责任。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">其次，此次事件所形成的舆论危机，给不了360太多挣扎的机会。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">在360回归A股上市之后，周鸿祎的言行显然收敛了许多。乌镇互联网大会上，还与马化腾、傅盛等昔日对手坐到了同一个饭桌上，友好的局面，显然是为了给360的顺利发展进行舆论铺垫。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">然而，水滴直播的负面舆论不仅打破了周鸿祎努力营造的友好局面，其负面影响力也超越了周鸿祎的预料，成为他无法抗争的困局。更可怕的是，这一次周鸿祎连对手都找不到，尽管他一再指责陈菲菲是黑公关，但是也不过是诛心之论，并没有找到证据。点燃大炮的周鸿祎，却始终难以找到一个明确的目标。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">这样的局面，是周鸿祎无法破解的。负面舆论的持续发酵，必然会导致360的公关形象不断跌落，关闭水滴直播，可以将其视作「断臂自保」的必然动作。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\"><span style=\"font-weight: 700;\">关闭水滴直播，对360的影响有多大？</span></p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">尽管当前水滴直播对于360来说并非核心业务，但是关闭水滴直播，对360的负面影响却并不小。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">自2011年后，移动互联网的大潮，让360不得不面对转型的巨大挑战。以免费杀毒软件起家的360，早年成功占据了 PC 市场，但是面对移动互联网，360的优势正在衰减。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">在移动互联网的探索中，手机和直播，是360最明显的动作。然而，手机业务却错失了风口，360手机面对华为小米和 OV，几乎没有挑战成功的可能，百万级的销量，也无法支撑360对于移动互联网的战略布局。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">可直播业务同样不好过。2015年6月，360上线花椒直播，同年8月份，水滴直播上线。经过2年多的运营，时至今日，花椒直播仍旧没有找到足以支撑战略的盈利模式，周鸿祎对于直播、游戏以及社交方面的认知短板，也导致了他在直播平台的发展上找不到方向。</p><p style=\"margin-top: 10px;\"><br></p><p style=\"margin-top: 10px;\">而水滴直播，相比花椒存在感更加薄弱，不仅不赚钱，也没有什么影响力。但是，周鸿祎并不愿意抛弃这个「拖油瓶」，如今断然抛弃，也是面对舆论危机的无奈之举。</p></section>', '1121', '2'), ('3', '[{\"typeid\":\"1\",\"name\":\"\\u4e00\\u5bb6\\u95e81\",\"number\":\"1\",\"price\":\"0.01\"},{\"typeid\":\"2\",\"name\":\"\\u4eb2\\u5b50\",\"number\":\"2\",\"price\":\"90\"}]', '55凯见面会', '111', '1513232219', '1520006400', '1524844800', '/uploads/picture/20180226/d26cb0206e83bf8992538e3b7a41d4fc.png', '12', '10人成团', '海创园', '西湖龙井', '<section class=\"\" data-tools=\"135编辑器\" data-id=\"89465\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><section style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section data-width=\"100%\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section data-role=\"outer\" label=\"Powered by 135editor.com\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" data-tools=\"135编辑器\" data-id=\"89465\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: medium; line-height: 25.6px; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; word-wrap: break-word !important;\">杭州古墩印象城于2009年</span><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; word-wrap: break-word !important;\">开业，至今已有</span><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; word-wrap: break-word !important;\">8载。开业至今</span><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; word-wrap: break-word !important;\">一直致力于为周边居民打造时尚，便利，有爱的精致型购物中心。</span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; text-align: center; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; word-wrap: break-word !important;\">8周年</span><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; word-wrap: break-word !important;\">庆典之际，</span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; text-align: center; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; word-wrap: break-word !important;\">古墩印象城品味再升级！</span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; word-wrap: break-word !important;\"><img class=\"\" data-ratio=\"0.6745468873128447\" data-src=\"https://mmbiz.qpic.cn/mmbiz_png/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5FMkBRlJONa3eF2uFFicraibx2MVMqb1VDrPPnBk2fNvqgD7U6ffNYYgw/?wx_fmt=png\" data-type=\"png\" data-w=\"1269\" _width=\"auto\" src=\"https://mmbiz.qpic.cn/mmbiz_png/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5FMkBRlJONa3eF2uFFicraibx2MVMqb1VDrPPnBk2fNvqgD7U6ffNYYgw/?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: auto !important;\"></span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 2em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(235, 103, 148); word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; line-height: 25.6px; font-size: 14px; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></span></strong></span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 2em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; background-image: initial; background-position: initial; background-size: initial; background-repeat: initial; background-attachment: initial; background-origin: initial; background-clip: initial; word-wrap: break-word !important;\"></span><span style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(235, 103, 148); word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; line-height: 25.6px; font-size: 14px; word-wrap: break-word !important;\">超级物种</span></strong></span><span style=\"margin: 0px; padding: 0px; max-width: 100%; line-height: 25.6px; color: rgb(63, 63, 63); font-size: 14px; word-wrap: break-word !important;\">，这家名字听着就非常新奇特的店上个月刚在上海开业。据说，这家24小时不打烊的新店火爆到不行，被称为<strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\">“史上ZUI强美食梦工厂”！</strong></span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 2em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; line-height: 25.6px; color: rgb(63, 63, 63); font-size: 14px; word-wrap: break-word !important;\"><img class=\"\" data-ratio=\"0.7922535211267606\" data-src=\"https://mmbiz.qpic.cn/mmbiz_png/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO50hYDaNPYvqlCIEmgjZjngDWpf6M26YGTTgNacPEPfGEO5NyI2WyEhg/640?wx_fmt=png\" data-type=\"png\" data-w=\"568\" _width=\"auto\" src=\"https://mmbiz.qpic.cn/mmbiz_png/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO50hYDaNPYvqlCIEmgjZjngDWpf6M26YGTTgNacPEPfGEO5NyI2WyEhg/640?wx_fmt=png&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: auto !important;\"></span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 2em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; line-height: 25.6px; color: rgb(63, 63, 63); font-size: 14px; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 2em; text-align: center; word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; line-height: 25.6px; color: rgb(63, 63, 63); font-size: 14px; word-wrap: break-word !important;\">现在，这家店来杭州了！</span></strong></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 2em; text-align: center; word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; line-height: 25.6px; color: rgb(63, 63, 63); font-size: 14px; word-wrap: break-word !important;\">就坐落在古墩印象城一楼！</span></strong></p></section></section></section></section></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 1.75em; text-align: center; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\">古墩印象城8周年店庆第一趴</span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; text-align: center; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\">让超级物种为你献上饕餮盛宴！</span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; display: inline-block; width: 668px; vertical-align: top; background-color: rgb(40, 40, 40); word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 20px 0px 10px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; display: inline-block; vertical-align: top; width: 133.594px; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; text-align: center; color: rgb(255, 255, 255); font-size: 12px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\">探店杭州</p></section></section></section><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 2px 0px 0px; padding: 0px; max-width: 100%; text-align: center; transform: translate3d(0px, 0px, 0px); word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: 4px; color: rgb(255, 255, 255); background-color: rgb(235, 103, 148); word-wrap: break-word !important;\"></section></section></section></section><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; display: inline-block; vertical-align: top; width: 133.594px; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; text-align: center; color: rgb(255, 255, 255); font-size: 12px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\">美食攻略</p></section></section></section></section><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; display: inline-block; vertical-align: top; width: 133.594px; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; text-align: center; color: rgb(255, 255, 255); font-size: 12px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p></section></section></section></section><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; display: inline-block; vertical-align: top; width: 133.594px; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; text-align: center; transform: translate3d(0px, 0px, 0px); word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(255, 255, 255); font-size: 12px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\">西湖区</p></section></section></section></section><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; display: inline-block; vertical-align: top; width: 133.594px; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; text-align: center; color: rgb(235, 103, 148); font-size: 12px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(255, 255, 255); word-wrap: break-word !important;\">超级物种</span></p></section></section></section></section></section></section></section></section></section><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 10px 0px; padding: 0px; max-width: 100%; text-align: center; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; vertical-align: middle; display: inline-block; word-wrap: break-word !important; overflow: hidden !important;\"><img class=\"__bg_gif \" data-ratio=\"0.6644444\" data-src=\"https://mmbiz.qpic.cn/mmbiz_gif/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5fMbGDYkjqiao9wFepQaKicC77HoEcBCAvRqrl3SBDTyt3ibO83ta9yAcA/?wx_fmt=gif\" data-type=\"gif\" data-w=\"900\" width=\"auto\" _width=\"auto\" src=\"https://mmbiz.qpic.cn/mmbiz_gif/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5fMbGDYkjqiao9wFepQaKicC77HoEcBCAvRqrl3SBDTyt3ibO83ta9yAcA/?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-order=\"1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: auto !important;\"></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p></section><section data-width=\"100%\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 1em; line-height: 25.6px; widows: 1; text-align: center; text-decoration: inherit; color: rgb(254, 254, 254); border-color: rgb(235, 103, 148); display: inline-block; width: 668px; word-wrap: break-word !important;\"><section style=\"margin: 0px; padding: 2px 0px 0px; max-width: 100%; color: rgb(255, 255, 255); background-color: rgb(235, 103, 148); word-wrap: break-word !important;\"><section style=\"margin: 0px; padding: 0.5em 1.5em; max-width: 100%; border-top: 1px solid rgb(254, 254, 254); border-right-color: rgb(235, 103, 148); border-bottom-color: rgb(235, 103, 148); border-left-color: rgb(235, 103, 148); word-wrap: break-word !important;\"><p class=\"\" data-brushtype=\"text\" style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; font-size: 20px; line-height: 20px; word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\">“超级物种”是一个怎样的神奇物种？</strong></p></section></section><section style=\"margin: 0px auto; padding: 0px; max-width: 100%; width: 0px; border-top: 0.8em solid rgb(235, 103, 148); border-bottom-color: rgb(235, 103, 148); height: 10px; word-wrap: break-word !important; border-left: 0.8em solid transparent !important; border-right: 0.8em solid transparent !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; text-align: center; line-height: normal; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 20px; word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><span class=\"\" data-brushtype=\"text\" style=\"margin: 0px; padding: 0px; max-width: 100%; line-height: inherit; word-wrap: break-word !important;\">高端超市+食材餐饮+永辉生活app</span></strong></span><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: normal; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 2em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\">超级物种是永辉于2017年创立的全新品牌，通过高端超市+食材餐饮体验+永辉生活APP商业模式，满足现代城市新消费、新生活需求。</span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 2em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\">简单地说，这既是一家超市，也是一家餐厅，还同时提供线上送餐服务，简直是外卖党的福音！</span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; text-align: center; word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 24px; color: rgb(235, 103, 148); word-wrap: break-word !important;\">古墩象城品味升级第一趴</span></strong></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><section class=\"\" data-tools=\"135编辑器\" data-id=\"91030\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section style=\"margin: 0px; padding: 0px; max-width: 100%; text-align: center; word-wrap: break-word !important;\"><section style=\"margin: 0px; padding: 0px; max-width: 100%; display: inline-block; width: 50px; word-wrap: break-word !important;\"><img class=\"__bg_gif \" data-ratio=\"1\" data-src=\"https://mmbiz.qpic.cn/mmbiz_gif/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO54sRic5vYWziaFF0UkRrvkeplv5UtkngSpDVOWp8KOHYOzVzPP9KDveSg/?wx_fmt=gif\" data-type=\"gif\" data-w=\"200\" title=\"分割线 gif 动图\" width=\"50px\" _width=\"50px\" src=\"https://mmbiz.qpic.cn/mmbiz_gif/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO54sRic5vYWziaFF0UkRrvkeplv5UtkngSpDVOWp8KOHYOzVzPP9KDveSg/?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-order=\"2\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; display: inline; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: 50px !important;\"></section></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 2em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(63, 63, 63); font-size: 14px; word-wrap: break-word !important;\">2017年2月16日，相信古墩印象城超级物种的到来，会给周边居民带来更多的幸福感！</span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 2em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(63, 63, 63); font-size: 14px; word-wrap: break-word !important;\">因为我们有...</span></p><section style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 10px 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; width: 668px; color: rgb(255, 255, 255); background: -webkit-linear-gradient(left, rgb(231, 133, 166), rgba(255, 247, 234, 0)) rgb(235, 103, 148); word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 5px 10px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 19px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\">能尝到纯净海洋气息的三文鱼</strong></span></p></section></section></section></section></section></section></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><img class=\"\" data-copyright=\"0\" data-ratio=\"0.6671875\" data-s=\"300,640\" data-src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5wnW3KGn1O3nIPfkCQyu8OMc6FwVSicsr4wSzHb7qctUq6LVs6Nv7icuw/?wx_fmt=jpeg\" data-type=\"jpeg\" data-w=\"640\" width=\"auto\" _width=\"auto\" src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5wnW3KGn1O3nIPfkCQyu8OMc6FwVSicsr4wSzHb7qctUq6LVs6Nv7icuw/?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: auto !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; letter-spacing: 0px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"></span></p><section style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 10px 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; width: 668px; color: rgb(255, 255, 255); background: -webkit-linear-gradient(left, rgb(231, 133, 166), rgba(255, 247, 234, 0)) rgb(235, 103, 148); word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 5px 10px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 19px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\">个大味美的波士顿龙虾</strong></span></p></section></section></section></section></section></section></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><img class=\"__bg_gif \" data-backh=\"295\" data-backw=\"450\" data-copyright=\"0\" data-ratio=\"0.6555555555555556\" data-src=\"https://mmbiz.qpic.cn/mmbiz_gif/icrgs8iaBo7ewqDRZvUhSJQKvYD0vRNQArFNjiaQicCBqvpoOwvBhjagz5NNiauKjHjrZFqD0dZFviaAdEJuko9DMH8w/?wx_fmt=gif\" data-type=\"gif\" data-w=\"450\" width=\"100%\" _width=\"670px\" src=\"https://mmbiz.qpic.cn/mmbiz_gif/icrgs8iaBo7ewqDRZvUhSJQKvYD0vRNQArFNjiaQicCBqvpoOwvBhjagz5NNiauKjHjrZFqD0dZFviaAdEJuko9DMH8w/?wx_fmt=gif&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-order=\"3\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; line-height: 25.6px; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: 670px !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; letter-spacing: 0px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"></span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><section style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 10px 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; width: 668px; color: rgb(255, 255, 255); background: -webkit-linear-gradient(left, rgb(231, 133, 166), rgba(255, 247, 234, 0)) rgb(235, 103, 148); word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 5px 10px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 19px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\">新鲜到张牙舞爪的阿拉斯加帝王蟹</strong></span></p></section></section></section></section></section></section></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><img class=\"\" data-backh=\"333\" data-backw=\"500\" data-copyright=\"0\" data-ratio=\"0.666\" data-s=\"300,640\" data-src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5iaEy54jnls8hGDCv7icbYibTQOoFbZYnCZAu4DVxMdMbQucgiaOYtkNKgQ/?wx_fmt=jpeg\" data-type=\"jpeg\" data-w=\"500\" width=\"100%\" _width=\"668px\" src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5iaEy54jnls8hGDCv7icbYibTQOoFbZYnCZAu4DVxMdMbQucgiaOYtkNKgQ/?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: 668px !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; letter-spacing: 0px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"></span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><section style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 10px 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; width: 668px; color: rgb(255, 255, 255); background: -webkit-linear-gradient(left, rgb(231, 133, 166), rgba(255, 247, 234, 0)) rgb(235, 103, 148); word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 5px 10px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 19px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\">鲜嫩多汁的进口牛排</strong></span></p></section></section></section></section></section></section></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><img class=\"\" data-backh=\"533\" data-backw=\"533\" data-copyright=\"0\" data-cropselx1=\"0\" data-cropselx2=\"533\" data-cropsely1=\"0\" data-cropsely2=\"400\" data-ratio=\"1\" data-s=\"300,640\" data-src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5SwPFyW2q8fmqVuHGeFticatZG8FamVwS1BUZRwSsBdibAD3MX7Tavyrw/?wx_fmt=jpeg\" data-type=\"jpeg\" data-w=\"1280\" width=\"100%\" _width=\"668px\" src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5SwPFyW2q8fmqVuHGeFticatZG8FamVwS1BUZRwSsBdibAD3MX7Tavyrw/?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: 668px !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><section style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 10px 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; width: 668px; color: rgb(255, 255, 255); background: -webkit-linear-gradient(left, rgb(231, 133, 166), rgba(255, 247, 234, 0)) rgb(235, 103, 148); word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 5px 10px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 19px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-weight: 700; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\">全世界老餮的梦幻美食——法国吉拉多生蚝</span></p></section></section></section></section></section></section></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><img class=\"\" data-backh=\"333\" data-backw=\"500\" data-copyright=\"0\" data-ratio=\"0.666\" data-s=\"300,640\" data-src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5umlcRsow0dcBvZhMbhyH2b1krKPstlyVjibra65TD6YHtnYzAJxDtibg/?wx_fmt=jpeg\" data-type=\"jpeg\" data-w=\"500\" width=\"100%\" _width=\"668px\" src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5umlcRsow0dcBvZhMbhyH2b1krKPstlyVjibra65TD6YHtnYzAJxDtibg/?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: 668px !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; letter-spacing: 0px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"></span></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; word-wrap: break-word !important;\"><br style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"></p><section style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 10px 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; width: 668px; color: rgb(255, 255, 255); background: -webkit-linear-gradient(left, rgb(231, 133, 166), rgba(255, 247, 234, 0)) rgb(235, 103, 148); word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 5px 10px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 19px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\">轻食主义者最爱的缤纷沙拉</strong></span></p></section></section></section></section></section></section></section></section><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><img class=\"\" data-backh=\"300\" data-backw=\"534\" data-copyright=\"0\" data-ratio=\"0.5617977528089888\" data-s=\"300,640\" data-src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5kIElhMpYCwfaibK80LvQ7pnHDRo4DzTbg2R7sJrrA5mQhvY2DLYn5Rw/?wx_fmt=jpeg\" data-type=\"jpeg\" data-w=\"534\" width=\"100%\" _width=\"668px\" src=\"https://mmbiz.qpic.cn/mmbiz_jpg/0y9ibmULDTbAakUKKHQKlxmfpYccEvsO5kIElhMpYCwfaibK80LvQ7pnHDRo4DzTbg2R7sJrrA5mQhvY2DLYn5Rw/?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; visibility: visible !important; width: 668px !important;\"></p><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; color: rgb(62, 62, 62); font-size: 16px; letter-spacing: 0px; widows: 1; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"></span></p><section style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 10px 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; width: 668px; color: rgb(255, 255, 255); background: -webkit-linear-gradient(left, rgb(231, 133, 166), rgba(255, 247, 234, 0)) rgb(235, 103, 148); word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 5px 10px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 19px; word-wrap: break-word !important;\"><p style=\"margin-bottom: 0px; padding: 0px; max-width: 100%; clear: both; min-height: 1em; line-height: 1.75em; word-wrap: break-word !important;\"><span style=\"margin: 0px; padding: 0px; max-width: 100%; font-size: 14px; color: rgb(63, 63, 63); word-wrap: break-word !important;\"><strong style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\">香气浓郁的面包和咖啡</strong></span></p></section></section></section></section></section></section></section></section><section style=\"margin: 0px; padding: 0px; max-width: 100%; color: rgb(62, 62, 62); font-size: 16px; line-height: 25.6px; widows: 1; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; text-align: center; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px 2px 0px 0px; max-width: 100%; display: inline-block; vertical-align: top; width: 334px; word-wrap: break-word !important;\"><section class=\"\" data-color=\"rgb(235, 103, 148)\" style=\"margin: 0px; padding: 0px; max-width: 100%; border-width: 0px; border-style: none; border-color: initial; word-wrap: break-word !important;\"><section style=\"margin: 0px; padding: 0px; max-width: 100%; font-family: &quot;Helvetica Neue&quot;, Helvetica, &quot;Hiragino Sans GB&quot;, &quot;Microsoft YaHei&quot;, Arial, sans-serif; word-wrap: break-word !important;\"><section class=\"\" powered-by=\"xiumi.us\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 10px 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; display: inline-block; width: 332px; vertical-align: top; word-wrap: break-word !important;\"><section class=\"\" powered-by=\"xiumi.us\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 5px 0px 10px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px 5px 0px 0px; max-width: 100%; display: inline-block; vertical-align: bottom; width: 166px; word-wrap: break-word !important;\"><section class=\"\" powered-by=\"xiumi.us\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; vertical-align: middle; display: inline-block; border-top: 0px none rgb(62, 62, 62); border-top-left-radius: 30px; word-wrap: break-word !important; overflow: hidden !important;\"><img data-src=\"http://mmbiz.qpic.cn/mmbiz_jpg/cTiaWbF77CGHw9iaG7p4F6czHAxmYicicGCXV6e5msckpbquv4UfXHHdL4YVmMgDqatibLB3u1T5HuicRprnhtB8xelQ/0?wx_fmt=jpeg\" data-ratio=\"0.8178138\" data-w=\"494\" data-type=\"jpeg\" class=\"\" src=\"http://mmbiz.qpic.cn/mmbiz_jpg/cTiaWbF77CGHw9iaG7p4F6czHAxmYicicGCXV6e5msckpbquv4UfXHHdL4YVmMgDqatibLB3u1T5HuicRprnhtB8xelQ/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; width: auto !important; visibility: visible !important;\"></section></section></section></section><section class=\"\" style=\"margin: 0px; padding: 0px 0px 0px 5px; max-width: 100%; display: inline-block; vertical-align: bottom; width: 166px; word-wrap: break-word !important;\"><section class=\"\" powered-by=\"xiumi.us\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; word-wrap: break-word !important;\"><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; vertical-align: middle; display: inline-block; border-top: 0px none rgb(62, 62, 62); border-top-left-radius: 0px; border-right: 3px none rgb(62, 62, 62); border-top-right-radius: 30px; word-wrap: break-word !important; overflow: hidden !important;\"><img data-src=\"http://mmbiz.qpic.cn/mmbiz_jpg/cTiaWbF77CGHw9iaG7p4F6czHAxmYicicGCXJ3RLYMB43OniasibXZroWgOUnfia84HVwWoiaNuUmoLv0MOpFpQiayaQSkQ/0?wx_fmt=jpeg\" data-ratio=\"0.8143382\" data-w=\"544\" data-type=\"jpeg\" class=\"\" src=\"http://mmbiz.qpic.cn/mmbiz_jpg/cTiaWbF77CGHw9iaG7p4F6czHAxmYicicGCXJ3RLYMB43OniasibXZroWgOUnfia84HVwWoiaNuUmoLv0MOpFpQiayaQSkQ/640?wx_fmt=jpeg&amp;tp=webp&amp;wxfrom=5&amp;wx_lazy=1\" data-fail=\"0\" style=\"margin: 0px; padding: 0px; max-width: 100%; height: auto !important; word-wrap: break-word !important; width: auto !important; visibility: visible !important;\"></section></section><div><section class=\"\" style=\"margin: 0px; padding: 0px; max-width: 100%; vertical-align: middle; display: inline-block; border-top: 0px none rgb(62, 62, 62); border-top-left-radius: 0px; border-right: 3px none rgb(62, 62, 62); border-top-right-radius: 30px; word-wrap: break-word !important; overflow: hidden !important;\"><br></section></div></section></section></section></section></section></section></section></section></section></section></section></section>', '<p>1</p>', '1', '0'), ('16', '[{\"typeid\":\"1\",\"name\":\"111\",\"number\":\"109\",\"price\":\"12\"},{\"typeid\":\"2\",\"name\":\"222\",\"number\":\"2\",\"price\":\"22\"}]', '测试测试', null, '1513732051', '1514563200', null, '/uploads/picture/20171220\\9b1978c601e61c3cfc2f2ed4f2ae98d3.JPEG', '111', null, '海创大厦', '海创科技园', '<p>111</p>', '<p>111</p>', null, '2'), ('17', '[{\"typeid\":\"1\",\"name\":\"\\u4e00\\u4e2a\\u4eba\",\"number\":\"1\",\"price\":\"100000\"}]', '穿越沙哈拉', null, '1513775492', '1513785600', null, '/uploads/picture/20171220\\aef9cf655c67239627625983d0a97df5.JPG', '1', null, '沙哈拉', '沙哈拉', '<p>你不行！</p>', '<p>做不到！</p>', null, '2'), ('18', '[{\"typeid\":\"1\",\"name\":\"\\u4e00\\u4e2a\\u4eba\\u5403\",\"number\":\"1\",\"price\":\"100\"},{\"typeid\":\"2\",\"name\":\"\\u4e24\\u4e2a\\u4eba\\u5403\",\"number\":\"2\",\"price\":\"250\"}]', '周四回家吃鱼', null, '1514428976', '1514476800', null, '/uploads/picture/20171228\\fa5e1299658c1271abdcae9a899799ab.png', '3', null, '海创大厦', '海创大厦', '<p>迟迟吃吃吃&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</p>', '<p>呵呵呵呵呵呵呵呵</p>', null, '2'), ('19', '[{\"typeid\":\"1\",\"name\":\"1\",\"number\":\"1\",\"price\":\"1\"}]', '今天的活动', null, '1514450060', '1514390400', '1514476799', '/uploads/picture/20171228\\7fb790993e15d57126b21707d291c8eb.png', '1', '1', '1', '1', '<p>1</p>', '<p>1</p>', null, '2'), ('20', '[{\"typeid\":\"1\",\"name\":\"\\u6d4b\\u8bd5\",\"number\":\"1\",\"price\":\"0.01\"}]', '11', 'zyf', '1514873758', '1520092800', '1551628800', '/uploads/picture/20180102/04332605a706efa30467fdf358afb332.jpg', '100', '1000', '11', '11', '<p>123</p>', '<p>213</p>', null, '2'), ('21', '[{\"typeid\":\"1\",\"name\":\"\\u6e38\\u73a9\",\"number\":\"2\",\"price\":\"0.01\"}]', '测试的活动', '这就是一个分享标题', '1519806832', '1519833600', '1519833600', '/uploads/picture/20180228/c80f38af24a87fc23948e84f263cb103.png', '', '', '杭州', '上海', '<p><br></p>', '<p><br></p>', null, '2');
COMMIT;

-- ----------------------------
--  Table structure for `tb_activity_comment`
-- ----------------------------
DROP TABLE IF EXISTS `tb_activity_comment`;
CREATE TABLE `tb_activity_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `activity_id` int(11) DEFAULT NULL COMMENT '活动id',
  `openid` varchar(255) DEFAULT NULL COMMENT '用户id',
  `type_id` int(11) DEFAULT NULL COMMENT '报名类型',
  `name` varchar(255) DEFAULT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `status` tinyint(4) DEFAULT '1' COMMENT '-1 删除 0 未支付 1 支付成功 2 退款 ，3退款中',
  `create_time` int(11) DEFAULT NULL COMMENT '报名时间',
  `out_trade_no` varchar(50) DEFAULT NULL COMMENT '系统内部订单',
  `total_fee` int(11) DEFAULT NULL,
  `jylsh` varchar(80) DEFAULT NULL COMMENT '交易流水号',
  `money` varchar(30) DEFAULT NULL COMMENT '交易金额，单位分',
  `pay_time` int(11) DEFAULT NULL COMMENT '支付时间',
  `refund_time` varchar(40) DEFAULT NULL COMMENT '退款时间',
  `refund_id` varchar(40) DEFAULT NULL COMMENT '微信退款单号',
  `out_refund_no` varchar(70) DEFAULT NULL COMMENT '商户退款单号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='活动订单表';

-- ----------------------------
--  Records of `tb_activity_comment`
-- ----------------------------
BEGIN;
INSERT INTO `tb_activity_comment` VALUES ('1', '3', '', '1', '1', '1', 'q', '2', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '1', '1519371308', '2018-02-23 15:35:38', '50000706062018022303624673623', '4200000076201802237056788463'), ('2', '2', '', '1', '2', '9', 'w', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '2', '1519371308', null, null, null), ('3', '1', '', '1', '3', '8', 'e', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '3', '1519371308', null, null, null), ('4', '4', '', '1', '4', '7', 'r', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '4', '1519371308', null, null, null), ('5', '5', '', '1', '5', '6', 't', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '5', '1519371308', null, null, null), ('6', '6', '', '1', '6', '5', 'y', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '6', '1519371308', null, null, null), ('7', '3', '', '1', '7', '4', 'u', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '7', '1519371308', null, null, null), ('8', '7', '', '1', '8', '3', 'i', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '8', '1519371308', null, null, null), ('9', '3', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '9', '2', 'a', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '9', '1519371308', null, null, null), ('10', '3', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '10', '1', 's', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '10', '1519371308', null, null, null), ('11', '3', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '11', '0', 'd', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '11', '1519371308', null, null, null), ('12', '3', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '12', '11', 'f', '1', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '12', '1519371308', null, null, null), ('13', '3', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '13', '12', 'g', '2', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '13', '1519371308', null, null, null), ('14', '3', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '14', '13', 'h', '2', '1519371291', '148237322220180223153451', null, '4200000076201802237056788463', '14', '1519371308', null, null, null), ('15', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '0', '1519718931', '148237322220180227160851', null, null, '2200', null, null, null, null), ('16', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '0', '1519719099', '148237322220180227161140', null, null, '2200', null, null, null, null), ('17', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '0', '1519722042', '148237322220180227170042', null, null, '2200', null, null, null, null), ('18', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '0', '1519781553', '148237322220180228093233', null, null, '1', null, null, null, null), ('19', '1', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '1', '2', '1519784712', '148237322220180228102512', null, '4200000057201802289729507868', '2', '1519784735', '2018-02-28 11:05:10', '50000405782018022803695327535', '4200000057201802289729507868'), ('20', '2', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '3', '3', '接口', '2', '1519786763', '148237322220180228105923', null, '4200000074201802289724243826', '3', '1519786768', '2018-02-28 11:05:38', '50000206062018022803681378014', '4200000074201802289724243826'), ('21', '3', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '2', '1519787268', '148237322220180228110748', null, '4200000077201802289655040296', '4', '1519787273', '2018-02-28 11:08:37', '50000006052018022803663228581', '4200000077201802289655040296'), ('22', '4', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '0', '1519787590', '148237322220180228111310', null, null, '5', null, null, null, null), ('23', '5', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '‘', '0', '1519787622', '148237322220180228111342', null, null, '6', null, null, null, null), ('24', '6', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '1', '0', '1519787660', '148237322220180228111420', null, null, '7', null, null, null, null), ('25', '7', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '0', '1519787822', '148237322220180228111702', null, null, '8', null, null, null, null), ('26', '8', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '2', '1519787833', '148237322220180228111714', null, '4200000054201802289770452852', '9', '1519787837', '2018-02-28 11:18:04', '50000405812018022803681975533', '4200000054201802289770452852'), ('27', '9', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '‘', '2', '1519788165', '148237322220180228112245', null, '4200000060201802289725991236', '10', '1519788170', '2018-02-28 11:23:08', '50000405952018022803663429262', '4200000060201802289725991236'), ('28', '10', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '2', '1519788451', '148237322220180228112732', null, '4200000051201802289681331541', '11', '1519788457', '2018-02-28 11:29:33', '50000505782018022803681628607', '4200000051201802289681331541'), ('29', '11', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '2', '1519788587', '148237322220180228112947', null, '4200000076201802289737043213', '12', '1519788593', '2018-02-28 11:34:47', '50000505772018022803664329509', '4200000076201802289737043213'), ('30', '12', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '2', '1519792203', '148237322220180228123003', null, '4200000056201802289734011719', '113', '1519792210', '2018-02-28 13:01:29', '50000705952018022803664781910', '4200000056201802289734011719'), ('31', '13', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '2', '1519792226', '148237322220180228123026', null, '4200000065201802289834270092', '14', '1519792235', '2018-02-28 12:46:13', '50000405772018022803680935360', '4200000065201802289834270092'), ('32', '14', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', 'd', 'd', 'd', '0', '1519793603', '148237322220180228125323', null, null, '15', null, null, null, null), ('33', '15', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', 'd', 'd', 'd', '0', '1519793607', '148237322220180228125327', null, null, '16', null, null, null, null), ('34', '16', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', 'd', 'd', 'dd', '0', '1519793714', '148237322220180228125514', null, null, '17', null, null, null, null), ('35', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', 'd', 'd', 'dd', '0', '1519793725', '148237322220180228125525', null, null, '18', null, null, null, null), ('36', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', 'd', 'd', 'dd', '0', '1519793726', '148237322220180228125526', null, null, '19', null, null, null, null), ('37', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '2', '1519794132', '148237322220180228130212', null, '4200000080201802289800537622', '20', '1519794138', '2018-02-28 13:02:46', '50000605782018022803681084801', '4200000080201802289800537622'), ('38', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '2', '1519794222', '148237322220180228130342', null, '4200000076201802289858886948', '21', '1519794226', '2018-02-28 13:05:19', '50000405982018022803663186013', '4200000076201802289858886948'), ('39', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '5', '6', '', '1', '1519794708', '148237322220180228131148', null, null, '22', null, null, null, null), ('40', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '5', '6', '', '1', '1519794730', '148237322220180228131211', null, null, '23', null, null, null, null), ('41', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '5', '6', '', '3', '1519794737', '148237322220180228131217', null, '4200000064201802289820509888', '24', '1519794741', null, null, null), ('42', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '1', '1519806181', '148237322220180228162301', null, null, '25', null, null, null, null), ('43', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '婆婆', '88', '', '1', '1519806638', '148237322220180228163039', null, null, '26', null, null, null, null), ('44', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '婆婆', '88', '', '1', '1519806686', '148237322220180228163127', null, null, '27', null, null, null, null), ('45', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '1', '1519866214', '148237322220180301090334', null, null, '28', null, null, null, null), ('46', '20', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', '1', '1', '1', '', '1', '1519866289', '148237322220180301090450', null, null, '29', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `tb_activity_order`
-- ----------------------------
DROP TABLE IF EXISTS `tb_activity_order`;
CREATE TABLE `tb_activity_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `out_trade_no` varchar(50) DEFAULT NULL COMMENT '系统内部订单号',
  `transaction_id` varchar(50) DEFAULT NULL,
  `total_fee` varchar(100) DEFAULT NULL COMMENT '支付总金额',
  `trade_type` varchar(20) DEFAULT NULL COMMENT '支付方式',
  `openid` varchar(50) DEFAULT NULL COMMENT '用户id',
  `status` int(4) DEFAULT NULL COMMENT '-1 删除 0未付款 1.取消付款 2.付款失败 3付款成功 4.已退款 ',
  `create_time` int(11) DEFAULT NULL,
  `paid_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
--  Table structure for `tb_activity_people`
-- ----------------------------
DROP TABLE IF EXISTS `tb_activity_people`;
CREATE TABLE `tb_activity_people` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `comment_id` int(11) DEFAULT NULL COMMENT '活动订单表id',
  `name` varchar(255) NOT NULL,
  `mobile` varchar(255) DEFAULT NULL,
  `people_card` varchar(255) DEFAULT NULL COMMENT '身份证',
  `emergency_contact` varchar(255) DEFAULT NULL COMMENT '紧急联系人',
  `status` int(11) DEFAULT '1' COMMENT '-1 删除     1正常。2 取消',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='活动出行人表';

-- ----------------------------
--  Records of `tb_activity_people`
-- ----------------------------
BEGIN;
INSERT INTO `tb_activity_people` VALUES ('1', '22', '1', '1', '1', '1', '1'), ('2', '23', '1', '1', '1', '1', '1'), ('3', '24', '1', '1', '1', '1', '1'), ('4', '25', '1', '1', '1', '1', '1'), ('5', '26', '1', '1', '1', '1', '2'), ('6', '27', '1', '1', '1', '1', '2'), ('7', '28', '1', '1', '11', '1', '2'), ('8', '29', '1', '1', '1', '1', '2'), ('9', '30', '1', '1', '1', '1', '2'), ('10', '31', '2', '2', '2', '2', '2'), ('11', '32', 'd', 'd', 'd', 'd', '1'), ('12', '33', 'd', 'd', 'd', 'd', '1'), ('13', '34', 'dd', 'd', 'dd', 'd', '1'), ('14', '35', 'dd', 'd', 'dd', 'd', '1'), ('15', '36', 'dd', 'd', 'dd', 'd', '1'), ('16', '37', '1', '1', '1', '1', '2'), ('17', '38', '1', '1', '1', '1', '2'), ('18', '39', '1', '2', '3', '4', '1'), ('19', '40', '1', '1', '1', '1', '1'), ('20', '41', '1', '1', '1', '1', '2'), ('21', '42', '1', '1', '111', '1', '1'), ('22', '45', 'Mr Mr', '18857120253', '1405', '1444', '1'), ('23', '46', 'Mr Mr', '18857120253', '1405', '1444', '2'), ('24', '46', '1', '1', '1', '1', '2'), ('25', '46', '1', '1', '1', '1', '2');
COMMIT;

-- ----------------------------
--  Table structure for `tb_auth_extend`
-- ----------------------------
DROP TABLE IF EXISTS `tb_auth_extend`;
CREATE TABLE `tb_auth_extend` (
  `group_id` mediumint(10) unsigned NOT NULL COMMENT '用户id',
  `extend_id` mediumint(8) unsigned NOT NULL COMMENT '扩展表中数据的id',
  `type` tinyint(1) unsigned NOT NULL COMMENT '扩展类型标识 1:栏目分类权限;2:模型权限',
  UNIQUE KEY `group_extend_type` (`group_id`,`extend_id`,`type`),
  KEY `uid` (`group_id`),
  KEY `group_id` (`extend_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='用户组与分类的对应关系表';

-- ----------------------------
--  Table structure for `tb_auth_group`
-- ----------------------------
DROP TABLE IF EXISTS `tb_auth_group`;
CREATE TABLE `tb_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户组id,自增主键',
  `module` varchar(20) NOT NULL DEFAULT '' COMMENT '用户组所属模块',
  `type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '组类型，2默认',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '用户组中文名称',
  `description` varchar(80) NOT NULL DEFAULT '' COMMENT '描述信息',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '用户组状态：为1正常，为0禁用,-1为删除',
  `rules` varchar(500) NOT NULL DEFAULT '' COMMENT '用户组拥有的规则id，多个规则 , 隔开',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='系统用户组';

-- ----------------------------
--  Records of `tb_auth_group`
-- ----------------------------
BEGIN;
INSERT INTO `tb_auth_group` VALUES ('1', 'admin', '1', '超级管理员', '', '1', ''), ('2', 'admin', '1', '管理员', '', '1', ''), ('3', 'admin', '1', '业务组', '', '1', ''), ('4', 'admin', '1', '财务组', '', '1', '20,39,42,44,45,46,52,53,55,56,58,59,61,66'), ('5', 'admin', '1', '默认组', '', '1', '1,2,3,4,5,6,7,8,12,13,14,16,17,18,19,21,22,23,24,25,26,27,34,36,38,41,42,43,53,55,56,58,59,61,66,70,76,77,78,79,80,81,82,83,84,85,86,87,95,96,97,98,99');
COMMIT;

-- ----------------------------
--  Table structure for `tb_auth_group_access`
-- ----------------------------
DROP TABLE IF EXISTS `tb_auth_group_access`;
CREATE TABLE `tb_auth_group_access` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(10) unsigned NOT NULL COMMENT '用户id',
  `group_id` mediumint(8) unsigned NOT NULL COMMENT '用户组id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COMMENT='用户和组对应权限';

-- ----------------------------
--  Records of `tb_auth_group_access`
-- ----------------------------
BEGIN;
INSERT INTO `tb_auth_group_access` VALUES ('1', '1', '1'), ('2', '15', '4'), ('17', '2', '5');
COMMIT;

-- ----------------------------
--  Table structure for `tb_auth_rule`
-- ----------------------------
DROP TABLE IF EXISTS `tb_auth_rule`;
CREATE TABLE `tb_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT COMMENT '规则id,自增主键',
  `module` varchar(20) NOT NULL COMMENT '规则所属module',
  `type` tinyint(2) NOT NULL DEFAULT '1' COMMENT '1-url;2-主菜单',
  `name` char(80) NOT NULL DEFAULT '' COMMENT '规则唯一英文标识',
  `title` char(20) NOT NULL DEFAULT '' COMMENT '规则中文描述',
  `status` tinyint(1) NOT NULL DEFAULT '1' COMMENT '是否有效(0:无效,1:有效)',
  `condition` varchar(300) NOT NULL DEFAULT '' COMMENT '规则附加条件',
  PRIMARY KEY (`id`),
  KEY `module` (`module`,`status`,`type`)
) ENGINE=MyISAM AUTO_INCREMENT=100 DEFAULT CHARSET=utf8 COMMENT='权限列表';

-- ----------------------------
--  Records of `tb_auth_rule`
-- ----------------------------
BEGIN;
INSERT INTO `tb_auth_rule` VALUES ('1', 'admin', '1', 'admin/User/add', '新增', '1', '1'), ('2', 'admin', '1', 'admin/User/edit', '编辑', '1', ''), ('3', 'admin', '1', 'admin/User/del', '删除', '1', ''), ('4', 'admin', '1', 'admin/User/changeStatus', '修改状态', '1', ''), ('5', 'admin', '1', 'admin/Action/add', '新增', '1', ''), ('6', 'admin', '1', 'admin/Action/edit', '编辑', '1', ''), ('7', 'admin', '1', 'admin/Action/del', '删除', '1', ''), ('8', 'admin', '1', 'admin/Action/changeStatus', '修改状态', '1', ''), ('9', 'admin', '1', 'admin/Auth/add', '新增', '-1', ''), ('10', 'admin', '1', 'admin/Auth/edit', '编辑', '-1', ''), ('11', 'admin', '1', 'admin/Auth/del', '删除', '-1', ''), ('12', 'admin', '1', 'admin/Auth/changeStatus', '修改状态', '1', ''), ('13', 'admin', '1', 'admin/Auth/user', '成员授权', '1', ''), ('14', 'admin', '1', 'admin/Auth/access', '访问授权', '1', ''), ('15', 'admin', '1', 'admin/Auth/group', '授权组', '-1', ''), ('16', 'admin', '1', 'admin/Auth/addToGroup', '保存成员授权', '1', ''), ('17', 'admin', '1', 'admin/Auth/removeFromGroup', '接触授权', '1', ''), ('18', 'admin', '1', 'admin/Action/view', '日志详情', '1', ''), ('19', 'admin', '1', 'admin/Action/remove', '删除日志', '1', ''), ('20', 'admin', '2', '1', '首页', '-1', ''), ('21', 'admin', '1', 'admin/User/index', '用户信息', '1', ''), ('22', 'admin', '2', 'admin/User/index', '后台用户', '1', ''), ('23', 'admin', '1', 'admin/Auth/index', '权限控制', '1', ''), ('24', 'admin', '2', 'admin/System/index', '系统配置', '1', ''), ('25', 'admin', '1', 'admin/Action/index', '用户行为', '1', ''), ('26', 'admin', '2', 'admin/Addons/index', '扩展插件', '1', ''), ('27', 'admin', '1', 'admin/Action/log', '行为日志', '1', ''), ('28', 'admin', '1', 'admin/Member/company', '游戏厂商', '-1', ''), ('29', 'admin', '1', 'admin/Project/index', '发布中的专案', '-1', ''), ('30', 'admin', '1', 'admin/Project/apply', '申请名单', '-1', ''), ('31', 'admin', '1', 'admin/Member/anchor', '视频主播', '-1', ''), ('32', 'admin', '1', 'admin/Member/companyDetail', '厂商详情', '-1', ''), ('33', 'admin', '1', 'admin/Member/anchorDetail', '主播详情', '-1', ''), ('34', 'admin', '1', 'admin/Config/group', '网站配置', '1', ''), ('35', 'admin', '2', 'admin/Project/index', '推广专案', '-1', ''), ('36', 'admin', '1', 'admin/Config/index', '配置属性', '1', ''), ('37', 'admin', '2', 'admin/Member/index', '前台用户', '-1', ''), ('38', 'admin', '1', 'admin/Menu/index', '菜单管理', '1', ''), ('39', 'admin', '2', 'admin/Finance/index', '财务结算', '-1', ''), ('40', 'admin', '1', 'admin/Channel/index', '业务导航', '-1', ''), ('41', 'admin', '1', 'admin/Database/export', '备份数据库', '1', ''), ('42', 'admin', '2', 'admin/Message/index', '消息管理', '1', ''), ('43', 'admin', '1', 'admin/Database/import', '还原数据库', '1', ''), ('44', 'admin', '1', 'admin/Finance/project', '结算专案', '-1', ''), ('45', 'admin', '1', 'admin/Finance/anchor', '支付主播', '-1', ''), ('46', 'admin', '1', 'admin/Finance/company', '厂商支付', '-1', ''), ('47', 'admin', '1', 'admin/Project/info', '详情', '-1', ''), ('48', 'admin', '1', 'admin/Project/check', '审核', '-1', ''), ('49', 'admin', '1', 'admin/Project/anchor', '管理视频', '-1', ''), ('50', 'admin', '1', 'admin/Project/video', '查看视频', '-1', ''), ('51', 'admin', '1', 'admin/Project/anchordetail', '主播详情', '-1', ''), ('52', 'admin', '1', 'admin/Finance/view', '查看详情', '-1', ''), ('53', 'admin', '1', 'admin/Message/view', '浏览', '1', ''), ('54', 'admin', '1', 'admin/Project/checkList', '提交审核的专案', '-1', ''), ('55', 'admin', '1', 'admin/Message/send', '发送消息', '1', ''), ('56', 'admin', '1', 'admin/Message/inbox', '收件箱', '1', ''), ('57', 'admin', '1', 'admin/Project/makeList', '制作中的专案', '-1', ''), ('58', 'admin', '1', 'admin/Message/index', '发件箱', '1', ''), ('59', 'admin', '1', 'admin/Message/draft', '草稿箱', '1', ''), ('60', 'admin', '1', 'admin/Project/finishList', '已完结的专案', '-1', ''), ('61', 'admin', '1', 'admin/Message/trash', '回收站', '1', ''), ('62', 'admin', '1', 'admin/Vote/video', '参赛视频', '-1', ''), ('63', 'admin', '1', 'admin/Vote/index', '投票统计', '-1', ''), ('64', 'admin', '1', 'admin/Vote/expert', '专家投票', '-1', ''), ('65', 'admin', '2', 'admin/Vote/index', '投票管理', '-1', ''), ('66', 'admin', '1', 'admin/Index/index', '首页', '1', ''), ('71', 'admin', '1', 'admin/Vote/show', '显示详情', '-1', ''), ('67', 'admin', '1', 'admin/Project/finish', '完结专案', '-1', ''), ('68', 'admin', '1', 'admin/Project/edit', '编辑专案', '-1', ''), ('69', 'admin', '1', 'admin/Project/addVideoData', '添加数据', '-1', ''), ('70', 'admin', '2', 'admin/Index/index', '首页', '1', ''), ('72', 'admin', '1', 'admin/Vote/vote', '投票', '-1', ''), ('73', 'admin', '1', 'admin/Finance/add', '添加支付', '-1', ''), ('74', 'admin', '1', 'admin/Finance/typeInfo', '类型信息', '-1', ''), ('75', 'admin', '1', 'admin/Finance/getInfo', '专案信息', '-1', ''), ('76', 'admin', '1', 'admin/Message/delete', '删除', '1', ''), ('77', 'admin', '1', 'admin/Message/moveToTrash', '移动到回收站', '1', ''), ('78', 'admin', '1', 'admin/User/updateHeader', '上传头像', '1', ''), ('79', 'admin', '1', 'admin/User/update', '更新信息', '1', ''), ('80', 'admin', '1', 'admin/Auth/createGroup', '创建组', '1', ''), ('81', 'admin', '1', 'admin/Auth/editGroup', '编辑组', '1', ''), ('82', 'admin', '1', 'admin/auth/updateRules', '更新节点', '1', ''), ('83', 'admin', '1', 'admin/Config/add', '新增配置', '1', ''), ('84', 'admin', '1', 'admin/Config/edit', '编辑', '1', ''), ('85', 'admin', '1', 'admin/Config/save', '批量保存', '1', ''), ('86', 'admin', '1', 'admin/Config/del', '删除配置', '1', ''), ('87', 'admin', '1', 'admin/Config/sort', '排序', '1', ''), ('88', 'admin', '1', 'admin/Menu/add', '新增', '1', ''), ('89', 'admin', '1', 'admin/Menu/edit', '编辑', '1', ''), ('90', 'admin', '1', 'admin/Menu/del', '删除', '1', ''), ('91', 'admin', '1', 'admin/Menu/toogleHide', '是否隐藏', '1', ''), ('92', 'admin', '1', 'admin/Menu/toogleDev', '是否开发', '1', ''), ('93', 'admin', '1', 'admin/Menu/sort', '排序', '1', ''), ('94', 'admin', '1', 'admin/Menu/getInfo', '菜单信息', '1', ''), ('95', 'admin', '1', 'admin/Database/optimize', '优化表', '1', ''), ('96', 'admin', '1', 'admin/Database/repair', '修复表', '1', ''), ('97', 'admin', '1', 'admin/Database/del', '删除备份', '1', ''), ('98', 'admin', '1', 'admin/Update/index', '补丁管理', '1', ''), ('99', 'admin', '1', 'admin/Update/update', '升级系统', '1', '');
COMMIT;

-- ----------------------------
--  Table structure for `tb_config`
-- ----------------------------
DROP TABLE IF EXISTS `tb_config`;
CREATE TABLE `tb_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '配置ID',
  `name` varchar(30) NOT NULL DEFAULT '' COMMENT '配置名称',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置类型',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '配置说明',
  `group` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '配置分组',
  `extra` varchar(255) NOT NULL DEFAULT '' COMMENT '配置值',
  `remark` varchar(100) NOT NULL DEFAULT '' COMMENT '配置说明',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '创建时间',
  `update_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '更新时间',
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '状态',
  `value` text COMMENT '配置值',
  `sort` smallint(3) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_name` (`name`),
  KEY `type` (`type`),
  KEY `group` (`group`)
) ENGINE=MyISAM AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 COMMENT='动态配置信息';

-- ----------------------------
--  Records of `tb_config`
-- ----------------------------
BEGIN;
INSERT INTO `tb_config` VALUES ('1', 'web_site_title', '1', '网站标题', '1', '', '网站标题前台显示标题', '1378898976', '1379235274', '1', '超级后台管理系统', '0'), ('2', 'web_site_description', '2', '网站描述', '1', '', '网站搜索引擎描述', '1378898976', '1379235841', '1', '广告管理平台', '1'), ('3', 'web_site_keyword', '2', '网站关键字', '1', '', '网站搜索引擎关键字', '1378898976', '1381390100', '1', '', '8'), ('4', 'web_site_close', '4', '关闭站点', '1', '0:关闭,1:开启', '站点关闭后其他用户不能访问，管理员可以正常访问', '1378898976', '1379235296', '1', '1', '1'), ('9', 'config_type_list', '3', '配置类型列表', '4', '', '主要用于数据解析和页面表单的生成', '1378898976', '1379235348', '1', '0:数字\r\n1:字符\r\n2:文本\r\n3:数组\r\n4:枚举', '2'), ('10', 'web_site_icp', '1', '网站备案号', '1', '', '设置在网站底部显示的备案号，如“沪icp备12007941号-2', '1378900335', '1379235859', '1', '', '9'), ('11', 'document_position', '3', '文档推荐位', '2', '', '文档推荐位，推荐到多个位置key值相加即可', '1379053380', '1379235329', '1', '1:列表推荐\r\n2:频道推荐\r\n4:首页推荐', '3'), ('12', 'document_display', '3', '文档可见性', '2', '', '文章可见性仅影响前台显示，后台不收影响', '1379056370', '1379235322', '1', '0:所有人可见\r\n1:仅注册会员可见\r\n2:仅管理员可见', '4'), ('13', 'color_style', '4', '后台色系', '1', 'default_color:默认\r\nblue_color:紫罗兰', '后台颜色风格', '1379122533', '1379235904', '1', 'default_color', '10'), ('20', 'config_group_list', '3', '配置分组', '4', '', '配置分组', '1379228036', '1469757555', '1', '1:基本\r\n2:内容\r\n3:用户\r\n4:系统\r\n5:业务\r\n6:SMTP', '4'), ('21', 'hooks_type', '3', '钩子的类型', '4', '', '类型 1-用于扩展显示内容，2-用于扩展业务处理', '1379313397', '1379313407', '1', '1:视图\r\n2:控制器', '6'), ('22', 'auth_config', '3', 'auth配置', '4', '', '自定义auth.class.php类配置', '1379409310', '1379409564', '1', 'auth_on:1\r\nauth_type:2', '8'), ('23', 'open_draftbox', '4', '是否开启草稿功能', '2', '0:关闭草稿功能\r\n1:开启草稿功能\r\n', '新增文章时的草稿功能配置', '1379484332', '1379484591', '1', '1', '1'), ('24', 'draft_aotosave_interval', '0', '自动保存草稿时间', '2', '', '自动保存草稿的时间间隔，单位：秒', '1379484574', '1386143323', '1', '60', '2'), ('25', 'list_rows', '0', '后台每页记录数', '2', '', '后台数据每页显示记录数', '1379503896', '1380427745', '1', '10', '10'), ('26', 'user_allow_register', '4', '是否允许用户注册', '3', '0:关闭注册\r\n1:允许注册', '是否开放用户注册', '1379504487', '1379504580', '1', '0', '3'), ('27', 'codemirror_theme', '4', '预览插件的codemirror主题', '4', '3024-day:3024 day\r\n3024-night:3024 night\r\nambiance:ambiance\r\nbase16-dark:base16 dark\r\nbase16-light:base16 light\r\nblackboard:blackboard\r\ncobalt:cobalt\r\neclipse:eclipse\r\nelegant:elegant\r\nerlang-dark:erlang-dark\r\nlesser-dark:lesser-dark\r\nmidnight:midnight', '详情见codemirror官网', '1379814385', '1384740813', '1', 'ambiance', '3'), ('28', 'data_backup_path', '1', '数据库备份根路径', '4', '', '路径必须以 / 结尾', '1381482411', '1381482411', '1', './data/', '5'), ('29', 'data_backup_part_size', '0', '数据库备份卷大小', '4', '', '该值用于限制压缩后的分卷最大长度。单位：b；建议设置20m', '1381482488', '1381729564', '1', '20971520', '7'), ('30', 'data_backup_compress', '4', '数据库备份文件是否启用压缩', '4', '0:不压缩\r\n1:启用压缩', '压缩备份文件需要php环境支持gzopen,gzwrite函数', '1381713345', '1381729544', '1', '1', '9'), ('31', 'data_backup_compress_level', '4', '数据库备份文件压缩级别', '4', '1:普通\r\n4:一般\r\n9:最高', '数据库备份文件的压缩级别，该配置在开启压缩时生效', '1381713408', '1381713408', '1', '9', '10'), ('32', 'develop_mode', '4', '开启开发者模式', '4', '0:关闭\r\n1:开启', '是否开启开发者模式', '1383105995', '1383291877', '1', '1', '11'), ('33', 'allow_visit', '3', '不受限控制器方法', '0', '', '', '1386644047', '1386644741', '1', '0:article/draftbox\r\n1:article/mydocument\r\n2:category/tree\r\n3:index/verify\r\n4:file/upload\r\n5:file/download\r\n6:user/updatepassword\r\n7:user/updatenickname\r\n8:user/submitpassword\r\n9:user/submitnickname\r\n10:file/uploadpicture', '0'), ('34', 'deny_visit', '3', '超管专限控制器方法', '0', '', '仅超级管理员可访问的控制器方法', '1386644141', '1386644659', '1', '0:addons/addhook\r\n1:addons/edithook\r\n2:addons/delhook\r\n3:addons/updatehook\r\n4:admin/getmenus\r\n5:admin/recordlist\r\n6:authmanager/updaterules\r\n7:authmanager/tree', '0'), ('35', 'reply_list_rows', '0', '回复列表每页条数', '2', '', '', '1386645376', '1387178083', '1', '10', '0'), ('36', 'admin_allow_ip', '2', '后台允许访问ip', '4', '', '多个用逗号分隔，如果不配置表示不限制ip访问', '1387165454', '1387165553', '1', '', '12'), ('37', 'show_page_trace', '4', '是否显示页面trace', '4', '0:关闭\r\n1:开启', '是否显示页面trace信息', '1387165685', '1387165685', '1', '0', '1'), ('38', 'web_company_name', '1', '公司名称', '1', '', '页面显示公司名字', '0', '0', '1', '虚空之翼', '0'), ('39', 'budget_list', '3', '预算额列表', '5', '', '', '0', '0', '1', '1:1,000以下\r\n2:1,000 -- 2,999\r\n3:3,000 -- 9,999\r\n4:10,000 -- 99,999\r\n5:100,000及以上', '0'), ('40', 'project_status_list', '3', '专案的状态', '5', '1:提交发布\r\n2:审核通过\r\n3:接案制作中\r\n4:完结', '', '0', '0', '1', '1:提交审核\r\n2:审核通过\r\n3:报名签约\r\n4:专案制作\r\n5:完结', '0'), ('41', 'message_type', '3', '消息发送对类型', '4', '', '', '0', '0', '1', '1:系统群发\r\n2:至厂商\r\n3:至主播', '0'), ('42', 'web_version', '0', '版本号', '1', '', '', '0', '0', '1', '0.8', '0'), ('43', 'mail_smtp', '1', 'stmp服务器', '6', '', '邮件的stmp服务器', '0', '0', '1', '', '0'), ('44', 'mail_username', '1', '邮箱帐号', '6', '', '发送服务器的帐号名', '0', '0', '1', '', '0'), ('45', 'mail_password', '1', '帐号密码', '6', '', '', '0', '0', '1', '', '0'), ('46', 'web_url', '1', '网站域名', '1', '', '网站的域名地址', '0', '0', '1', 'http://www.admin.com', '0');
COMMIT;

-- ----------------------------
--  Table structure for `tb_feedback`
-- ----------------------------
DROP TABLE IF EXISTS `tb_feedback`;
CREATE TABLE `tb_feedback` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT '' COMMENT '主题',
  `content` text COMMENT '反馈内容',
  `company` varchar(255) DEFAULT NULL COMMENT '反馈人-企业名称',
  `name` varchar(255) DEFAULT NULL COMMENT '反馈人-姓名',
  `mobile` varchar(255) DEFAULT NULL COMMENT '反馈人-手机号码',
  `reply` text,
  `create_user` varchar(200) DEFAULT NULL,
  `create_time` int(11) DEFAULT NULL,
  `reply_content` text,
  `reply_user` varchar(200) DEFAULT NULL,
  `reply_time` int(11) DEFAULT NULL,
  `park_id` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '0' COMMENT '0未回复。1已回复',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='反馈';

-- ----------------------------
--  Table structure for `tb_file`
-- ----------------------------
DROP TABLE IF EXISTS `tb_file`;
CREATE TABLE `tb_file` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文件ID',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '原始文件名',
  `savename` varchar(100) NOT NULL DEFAULT '' COMMENT '保存名称',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT '文件保存路径',
  `thumbnail` varchar(255) DEFAULT '' COMMENT '图片缩略图',
  `ext` char(5) NOT NULL DEFAULT '' COMMENT '文件后缀',
  `type` char(40) NOT NULL DEFAULT '' COMMENT '文件mime类型',
  `size` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文件大小',
  `md5` char(32) NOT NULL DEFAULT '' COMMENT '文件md5',
  `sha1` char(40) NOT NULL DEFAULT '' COMMENT '文件 sha1编码',
  `location` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '文件保存位置',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '远程地址',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上传时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_md5` (`md5`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='文件表';

-- ----------------------------
--  Records of `tb_file`
-- ----------------------------
BEGIN;
INSERT INTO `tb_file` VALUES ('1', 'logo.png', '94898592cf5133671555f5ab861ac3de.png', 'public/uploads/file/20161209/94898592cf5133671555f5ab861ac3de.png', null, 'png', 'image/png', '38592', 'ab5ad0c90ad269c3c199a0854874dc20', '8440199290a0f36f3dbb5885078c70129e0be6e7', '1', '', '1481266318'), ('2', 'logo_meitu_1.jpg', 'dc9194318c22aee62bb7a33101123807.jpg', 'public/uploads/file/20161209/dc9194318c22aee62bb7a33101123807.jpg', null, 'jpg', 'image/jpeg', '50069', '32a6f7854d40a9c6a1e2c99f8ec31ddb', '2a22671f69699fec2d23833b5ffbc660e3d16203', '1', '', '1481267441');
COMMIT;

-- ----------------------------
--  Table structure for `tb_mail`
-- ----------------------------
DROP TABLE IF EXISTS `tb_mail`;
CREATE TABLE `tb_mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `from` varchar(100) DEFAULT '' COMMENT '发件人',
  `to` varchar(100) DEFAULT '' COMMENT '收件人',
  `subject` varchar(255) DEFAULT '' COMMENT '标题',
  `body` text COMMENT '内容',
  `attachment` varchar(255) DEFAULT NULL COMMENT '附件',
  `create_time` int(11) DEFAULT '0',
  `create_user` int(11) DEFAULT '0',
  `update_time` int(11) DEFAULT '0',
  `delete_time` int(11) DEFAULT '0',
  `send_time` int(11) DEFAULT '0',
  `status` tinyint(4) DEFAULT '0' COMMENT '状态，-1删除、0草稿、1发送',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮件发送记录';

-- ----------------------------
--  Table structure for `tb_mail_signed`
-- ----------------------------
DROP TABLE IF EXISTS `tb_mail_signed`;
CREATE TABLE `tb_mail_signed` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `user_type` tinyint(4) DEFAULT '1' COMMENT '用户类型，1后台、2厂商、3主播',
  `signed` varchar(255) DEFAULT '' COMMENT '随机字符串验证信息',
  `effective_time` int(11) DEFAULT '0',
  `create_time` int(11) DEFAULT '0',
  `type` tinyint(4) DEFAULT '1' COMMENT '邮件类型，1激活帐号、2重置密码',
  `status` tinyint(4) DEFAULT '1' COMMENT '状态，0无效、1有效',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='邮件验证信息';

-- ----------------------------
--  Table structure for `tb_member`
-- ----------------------------
DROP TABLE IF EXISTS `tb_member`;
CREATE TABLE `tb_member` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '用户ID',
  `username` char(100) DEFAULT '' COMMENT '用户名',
  `password` char(32) DEFAULT NULL,
  `park_id` int(11) DEFAULT '0' COMMENT '对应园区id',
  `nickname` char(32) DEFAULT '' COMMENT '昵称',
  `header` varchar(255) DEFAULT NULL,
  `email` char(32) DEFAULT NULL,
  `mobile` char(15) DEFAULT NULL,
  `sex` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '性别',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `qq` char(10) NOT NULL DEFAULT '' COMMENT 'qq号',
  `score` mediumint(8) NOT NULL DEFAULT '0' COMMENT '用户积分',
  `login` int(11) DEFAULT NULL,
  `reg_time` int(11) DEFAULT NULL,
  `reg_ip` bigint(20) DEFAULT NULL,
  `last_login_time` int(11) DEFAULT NULL,
  `last_login_ip` bigint(20) DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '会员状态，0禁用，1正常',
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='会员表';

-- ----------------------------
--  Records of `tb_member`
-- ----------------------------
BEGIN;
INSERT INTO `tb_member` VALUES ('1', 'admin', '02571bc54a0a4c08451a187d1929b208', '0', 'admin12', '/uploads/header/2017-07-25/header_1500969355.png', '15161@qq.com', '18912345678', '0', '2016-05-23', '', '0', '159', null, null, '1519870198', '1033094521', '1'), ('2', 'test', 'ddfa43dd9b4565e5ad0b44e217421757', '0', 'test', null, '164166@qq.com', null, '0', null, '', '0', null, '1481245755', '2130706433', '1481245979', '2130706433', '1');
COMMIT;

-- ----------------------------
--  Table structure for `tb_menu`
-- ----------------------------
DROP TABLE IF EXISTS `tb_menu`;
CREATE TABLE `tb_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文档ID',
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '标题',
  `icon` varchar(50) DEFAULT '',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '上级分类ID',
  `level` tinyint(4) DEFAULT '1' COMMENT '菜单等级',
  `sort` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '排序（同级有效）',
  `url` char(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `hide` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否隐藏',
  `tip` varchar(255) NOT NULL DEFAULT '' COMMENT '提示',
  `group` varchar(50) DEFAULT '' COMMENT '分组',
  `is_dev` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否仅开发者模式可见',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`),
  KEY `status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=106 DEFAULT CHARSET=utf8 COMMENT='后台系统菜单';

-- ----------------------------
--  Records of `tb_menu`
-- ----------------------------
BEGIN;
INSERT INTO `tb_menu` VALUES ('1', '首页', 'fa-th-large', '0', '1', '2', 'Index/index', '0', '', '', '0', '1'), ('2', '后台用户', 'fa-user', '0', '1', '4', 'User/index', '0', '', '', '0', '1'), ('3', '系统配置', 'fa-cogs', '0', '1', '5', 'System/index', '0', '', '', '0', '1'), ('4', '扩展插件', 'fa-location-arrow', '0', '1', '6', 'Addons/index', '1', '', '', '0', '1'), ('5', '用户信息', '', '2', '2', '1', 'User/index', '0', '', '', '0', '1'), ('6', '权限控制', '', '2', '2', '2', 'Auth/index', '0', '', '', '0', '1'), ('7', '用户行为', '', '2', '2', '4', 'Action/index', '1', '', '', '0', '1'), ('8', '行为日志', '', '2', '2', '3', 'Action/log', '0', '', '', '0', '1'), ('9', '新增', '', '5', '3', '0', 'User/add', '0', '', '', '0', '1'), ('10', '编辑', '', '5', '3', '0', 'User/edit', '0', '', '', '0', '1'), ('11', '删除', '', '5', '3', '0', 'User/del', '0', '', '', '0', '1'), ('12', '修改状态', '', '5', '3', '0', 'User/changeStatus', '0', '', '', '0', '1'), ('13', '新增', '', '7', '3', '0', 'Action/add', '0', '', '', '0', '1'), ('14', '编辑', '', '7', '3', '0', 'Action/edit', '0', '', '', '0', '1'), ('15', '删除', '', '7', '3', '0', 'Action/del', '0', '', '', '0', '1'), ('16', '修改状态', '', '7', '3', '0', 'Action/changeStatus', '0', '', '', '0', '1'), ('17', '创建组', '', '6', '3', '0', 'Auth/createGroup', '0', '', '', '0', '1'), ('18', '编辑组', '', '6', '3', '0', 'Auth/editGroup', '0', '', '', '0', '1'), ('20', '修改状态', '', '6', '3', '0', 'Auth/changeStatus', '0', '', '', '0', '1'), ('21', '成员授权', '', '6', '3', '0', 'Auth/user', '0', '', '', '0', '1'), ('22', '访问授权', '', '6', '3', '0', 'Auth/access', '0', '', '', '0', '1'), ('87', '新增配置', '', '35', '3', '0', 'Config/add', '0', '', '', '0', '1'), ('24', '保存成员授权', '', '6', '3', '0', 'Auth/addToGroup', '0', '', '', '0', '1'), ('25', '接触授权', '', '6', '3', '0', 'Auth/removeFromGroup', '0', '', '', '0', '1'), ('26', '日志详情', '', '8', '3', '0', 'Action/view', '0', '', '', '0', '1'), ('27', '删除日志', '', '8', '3', '0', 'Action/remove', '0', '', '', '0', '1'), ('35', '配置属性', '', '3', '2', '2', 'Config/index', '0', '', '', '0', '1'), ('36', '网站配置', '', '3', '2', '1', 'Config/group', '0', '', '', '0', '1'), ('37', '菜单管理', '', '3', '2', '3', 'Menu/index', '0', '', '', '0', '1'), ('38', '备份数据库', '', '3', '2', '4', 'Database/export', '0', '', '', '0', '1'), ('39', '还原数据库', '', '3', '2', '5', 'Database/import', '0', '', '', '0', '1'), ('44', '消息管理', 'fa-envelope', '0', '1', '3', 'Message/index', '0', '', '', '0', '1'), ('45', '发送消息', '', '44', '2', '1', 'Message/send', '0', '', '', '0', '1'), ('46', '发件箱', '', '44', '2', '3', 'Message/index', '0', '', '', '0', '1'), ('47', '草稿箱', '', '44', '2', '4', 'Message/draft', '0', '', '', '0', '1'), ('48', '回收站', '', '44', '2', '5', 'Message/trash', '0', '', '', '0', '1'), ('49', '收件箱', '', '44', '2', '2', 'Message/inbox', '1', '', '', '0', '1'), ('62', '浏览', '', '46', '3', '0', 'Message/view', '0', '', '', '0', '1'), ('67', '首页', '', '1', '2', '0', 'Index/index', '1', '', '', '0', '1'), ('82', '删除', '', '46', '3', '0', 'Message/delete', '0', '', '', '0', '1'), ('83', '移动到回收站', '', '46', '3', '0', 'Message/moveToTrash', '0', '', '', '0', '1'), ('84', '上传头像', '', '5', '3', '0', 'User/updateHeader', '0', '', '', '0', '1'), ('85', '更新信息', '', '5', '3', '0', 'User/update', '0', '', '', '0', '1'), ('86', '更新节点', '', '6', '3', '0', 'auth/updateRules', '0', '', '', '0', '1'), ('88', '编辑', '', '35', '3', '0', 'Config/edit', '0', '', '', '0', '1'), ('89', '批量保存', '', '35', '3', '0', 'Config/save', '0', '', '', '0', '1'), ('90', '删除配置', '', '35', '3', '0', 'Config/del', '0', '', '', '0', '1'), ('91', '排序', '', '35', '3', '0', 'Config/sort', '0', '', '', '0', '1'), ('92', '新增', '', '40', '3', '0', 'Menu/add', '0', '', '', '0', '1'), ('93', '编辑', '', '40', '3', '0', 'Menu/edit', '0', '', '', '0', '1'), ('94', '删除', '', '40', '3', '0', 'Menu/del', '0', '', '', '0', '1'), ('95', '是否隐藏', '', '40', '3', '0', 'Menu/toogleHide', '0', '', '', '0', '1'), ('96', '是否开发', '', '40', '3', '0', 'Menu/toogleDev', '0', '', '', '0', '1'), ('97', '排序', '', '40', '3', '0', 'Menu/sort', '0', '', '', '0', '1'), ('98', '菜单信息', '', '40', '3', '0', 'Menu/getInfo', '0', '', '', '0', '1'), ('99', '优化表', '', '38', '3', '0', 'Database/optimize', '0', '', '', '0', '1'), ('100', '修复表', '', '38', '3', '0', 'Database/repair', '0', '', '', '0', '1'), ('101', '删除备份', '', '39', '3', '0', 'Database/del', '0', '', '', '0', '1'), ('103', '补丁管理', '', '3', '1', '6', 'Update/index', '0', '', '', '0', '1'), ('104', '升级系统', '', '3', '2', '7', 'Update/update', '0', '', '', '0', '1'), ('105', '活动报名', '', '0', '1', '1', 'activity/index', '0', '', '', '0', '1');
COMMIT;

-- ----------------------------
--  Table structure for `tb_message`
-- ----------------------------
DROP TABLE IF EXISTS `tb_message`;
CREATE TABLE `tb_message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT '' COMMENT '消息标题',
  `content` text COMMENT '主体内容',
  `attachment_id` varchar(50) DEFAULT '0' COMMENT '附件ID',
  `type` tinyint(4) DEFAULT '1' COMMENT '消息类型，1系统群发、2发送给厂商、3发送给用户',
  `send_id` int(11) DEFAULT '0' COMMENT '发件人，0系统',
  `receive_id` int(11) DEFAULT '0' COMMENT '收件人，0所有对象',
  `create_time` int(11) DEFAULT '0' COMMENT '创建时间',
  `send_time` int(11) DEFAULT '0' COMMENT '发送时间',
  `status` tinyint(4) DEFAULT '0' COMMENT '状态，-1删除、0草稿、1正常',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='内部消息';

-- ----------------------------
--  Table structure for `tb_message_status`
-- ----------------------------
DROP TABLE IF EXISTS `tb_message_status`;
CREATE TABLE `tb_message_status` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `message_id` int(11) DEFAULT '0',
  `member_id` int(11) DEFAULT '0',
  `is_view` tinyint(4) DEFAULT '0' COMMENT '是否已经查看，1已查看',
  `is_delete` tinyint(4) DEFAULT '0' COMMENT '是否删除，1删除',
  `type` tinyint(4) DEFAULT '1' COMMENT '用户类型，1后台、2厂商、3主播',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='消息内容的状态';

-- ----------------------------
--  Table structure for `tb_news`
-- ----------------------------
DROP TABLE IF EXISTS `tb_news`;
CREATE TABLE `tb_news` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `type` tinyint(4) DEFAULT '1' COMMENT '类型：1新闻速递、2园区通告、3好文分享、4相关活动、5政策、6法规',
  `front_cover` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '封面图片，填写路径',
  `is_banner` tinyint(4) DEFAULT '0' COMMENT '是否轮播',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '发布人',
  `views` int(11) DEFAULT '0' COMMENT '浏览量',
  `create_time` int(11) DEFAULT '0',
  `comments` int(11) DEFAULT '0' COMMENT '评论量',
  `update_time` int(11) DEFAULT '0',
  `create_user` int(11) DEFAULT '0',
  `is_send` tinyint(4) DEFAULT '0' COMMENT '是否推送',
  `park_id` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `id` (`id`) USING BTREE,
  KEY `is_send` (`is_send`) USING BTREE,
  KEY `status` (`status`) USING BTREE,
  KEY `is_banner` (`is_banner`) USING BTREE,
  KEY `create_time` (`create_time`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='新闻内容';

-- ----------------------------
--  Table structure for `tb_park`
-- ----------------------------
DROP TABLE IF EXISTS `tb_park`;
CREATE TABLE `tb_park` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `images` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `area_total` int(11) DEFAULT NULL COMMENT '总面积',
  `area_use` int(11) DEFAULT NULL COMMENT '在租',
  `area_other` int(11) DEFAULT NULL COMMENT '其他占用',
  `company_total` int(11) DEFAULT NULL,
  `company_in` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='园区';

-- ----------------------------
--  Table structure for `tb_pay_log`
-- ----------------------------
DROP TABLE IF EXISTS `tb_pay_log`;
CREATE TABLE `tb_pay_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_id` varchar(50) DEFAULT NULL COMMENT '订单号',
  `money` varchar(20) DEFAULT NULL COMMENT '金额',
  `openid` varchar(40) DEFAULT NULL COMMENT '用户openid',
  `status` tinyint(2) DEFAULT '0' COMMENT '订单状态值； 0为创建中，1为已支付,2取消支付',
  `aid` tinyint(4) DEFAULT NULL COMMENT '活动id',
  `time` int(11) DEFAULT NULL COMMENT '创建时间',
  `jylsh` varchar(40) DEFAULT NULL COMMENT '交易流水号',
  `trip` text COMMENT '出行人',
  `contacts` varchar(255) DEFAULT NULL COMMENT '联系人',
  `typeid` tinyint(4) DEFAULT NULL COMMENT '活动类型',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='订单支付表';

-- ----------------------------
--  Records of `tb_pay_log`
-- ----------------------------
BEGIN;
INSERT INTO `tb_pay_log` VALUES ('1', '20180202165346jhyscm1339372869', '10000', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', '0', '1', '1517561626', null, null, null, null), ('2', '20180202173102jhyscm1957090491', '10000', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', '0', '1', '1517563862', null, null, null, null), ('3', '20180205110213jhyscm1609310418', '10000', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', '0', '1', '1517799733', null, null, null, null), ('4', '20180205110841jhyscm1701683248', '10000', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', '0', '1', '1517800121', null, null, null, null), ('5', '20180205113437jhyscm1722197106', '10000', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', '0', '1', '1517801677', null, null, null, null), ('6', '20180205130225jhyscm1085834415', '10000', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', '0', '1', '1517806947', null, null, null, null), ('7', '20180205152113jhyscm1428489880', '10000', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', '0', '1', '1517815273', null, null, null, null), ('8', '20180205161152jhyscm1737848764', '10000', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', '0', '1', '1517818314', null, null, null, null), ('9', '20180205161346jhyscm1813596972', '10000', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', '0', '1', '1517818426', null, null, null, null);
COMMIT;

-- ----------------------------
--  Table structure for `tb_sms`
-- ----------------------------
DROP TABLE IF EXISTS `tb_sms`;
CREATE TABLE `tb_sms` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `to` char(16) DEFAULT '' COMMENT '接收手机号码',
  `content` varchar(255) DEFAULT '' COMMENT '短信内容',
  `create_time` int(11) DEFAULT '0' COMMENT '创建时间',
  `template_id` int(11) DEFAULT '0' COMMENT '模板ID',
  `result` varchar(255) DEFAULT '' COMMENT '发送后的返回码',
  `resp_code` char(6) DEFAULT '' COMMENT '发送后的返回码',
  `create_date` char(16) DEFAULT '' COMMENT '短信平台记录的时间',
  `sms_id` char(32) DEFAULT '' COMMENT '短信平台记录的ID',
  `status` tinyint(4) DEFAULT '0' COMMENT '0:成功；1：提交失败，4：失败，5：关键字（keys），6：黑/白名单，7：超频（overrate），8：unknown',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='短信发送记录';

-- ----------------------------
--  Table structure for `tb_sms_code`
-- ----------------------------
DROP TABLE IF EXISTS `tb_sms_code`;
CREATE TABLE `tb_sms_code` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `mobile` char(12) DEFAULT '' COMMENT '手机号码',
  `code` char(4) DEFAULT '' COMMENT '验证码',
  `create_time` int(11) DEFAULT '0' COMMENT '创建时间',
  `active_time` int(11) DEFAULT '0' COMMENT '有效期单位秒',
  `status` tinyint(4) DEFAULT '0' COMMENT '是否验证',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='发送验证码验证信息';

-- ----------------------------
--  Table structure for `tb_union`
-- ----------------------------
DROP TABLE IF EXISTS `tb_union`;
CREATE TABLE `tb_union` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `contact` varchar(255) DEFAULT NULL COMMENT '联系人',
  `mobile` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `office_time_start` time DEFAULT NULL,
  `office_time_end` time DEFAULT NULL,
  `park_id` int(11) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='工会';

-- ----------------------------
--  Table structure for `tb_wechat_department`
-- ----------------------------
DROP TABLE IF EXISTS `tb_wechat_department`;
CREATE TABLE `tb_wechat_department` (
  `id` int(11) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `parentid` int(11) DEFAULT NULL,
  `order` int(4) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='微信部门';

-- ----------------------------
--  Table structure for `tb_wechat_tag`
-- ----------------------------
DROP TABLE IF EXISTS `tb_wechat_tag`;
CREATE TABLE `tb_wechat_tag` (
  `tagid` int(11) NOT NULL,
  `tagname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`tagid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='微信标签';

-- ----------------------------
--  Table structure for `tb_wechat_user`
-- ----------------------------
DROP TABLE IF EXISTS `tb_wechat_user`;
CREATE TABLE `tb_wechat_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `openid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户的标识，对当前公众号唯一',
  `unionid` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT '' COMMENT '只有在用户将公众号绑定到微信开放平台帐号后，才会出现该字段',
  `nickname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户的昵称',
  `sex` tinyint(4) NOT NULL DEFAULT '0' COMMENT '用户的性别，值为1时是男性，值为2时是女性，值为0时是未知',
  `city` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户所在城市',
  `province` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户所在省份',
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户所在国家',
  `language` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '用户的语言，简体中文为zh_CN',
  `headimgurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT '' COMMENT '用户头像，最后一个数值代表正方形头像大小（有0、46、64、96、132数值可选，0代表640*640正方形头像），用户没有头像时该项为空。若用户更换头像，原有头像URL将失效。',
  `subscribe_time` int(11) NOT NULL DEFAULT '0' COMMENT '用户关注时间，为时间戳。如果用户曾多次关注，则取最后关注时间\n用户关注时间，为时间戳。如果用户曾多次关注，则取最后关注时间\n用户关注时间，为时间戳。如果用户曾多次关注，则取最后关注时间\n用户关注时间，为时间戳。如果用户曾多次关注，则取最后关注时间',
  `unsubscribe_time` int(11) DEFAULT '0' COMMENT '退订时间',
  `subscribe` tinyint(4) DEFAULT '0' COMMENT '用户是否订阅该公众号标识，值为0时，代表此用户没有关注该公众号，拉取不到其余信息。',
  `remark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '粉丝的备注',
  `groupid` char(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户所在的分组ID',
  `tagid_list` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '标签组',
  `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '后期逻辑处理标识,0取消关注、1关注',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='微信用户信息';

-- ----------------------------
--  Records of `tb_wechat_user`
-- ----------------------------
BEGIN;
INSERT INTO `tb_wechat_user` VALUES ('2', 'oSaaIwlSscRYyQEKxEKG6M2AELJs', '', '龙启良', '1', '宜春', '江西', '中国', 'zh_CN', 'http://wx.qlogo.cn/mmopen/vi_32/TNHBMAPvxy6tW83DxPwR2ErNcniaMdibn01ibibrRfhROQ8hJRicbTLvUIzg8Uiblhsp9RQZVuicND4s3MGQ8Vep5wP6g/0', '0', '0', '0', null, null, null, '1'), ('3', 'oSaaIwojY2sVAl6OyKycGFbTrO4o', '', '虚空之翼', '1', '杭州', '浙江', '中国', 'zh_CN', 'http://wx.qlogo.cn/mmopen/vi_32/Q0j4TwGTfTIxD7o4qePfnMkgNtbazxSl6OJia6ENBcuhTGBcpfKYVpQ3ibF15Qd51s2aiarj6DJYp7zu2vtzXcfbQ/0', '0', '0', '0', null, null, null, '1'), ('4', 'oSaaIwv54VD76WQAHAw4lf1mx7Mg', null, '汤姆船长', '1', '杭州', '浙江', '中国', 'zh_CN', 'http://wx.qlogo.cn/mmopen/dGffpiaogj1nYj0yticP7aMH8TVU5jsL0mvNYAfQSlJf1ia27fwobvdYN1LVJxaGqzic5YibBKxIsHwib2zpQcvP0tlCJguRKCxQfP/0', '1513588530', null, '1', '', '0', '[]', '1'), ('5', 'oSaaIwvKcLx1XhgibSpYPYM__hio', null, '二爸爸先生', '1', '杭州', '浙江', '中国', 'zh_CN', 'http://wx.qlogo.cn/mmopen/PiajxSqBRaELwicEibX1KLUzjLjEiaGicEbzqv3PuYb7H1fLduhGcRrpKdTFhVP09libxL4Y0Y2j0cmpJLZQB9qmJ7yw/0', '1513748326', null, '1', '', '0', '[]', '1'), ('6', 'oSaaIwhLgZfCKW95CE-bCvcjIy1s', null, '火奴鲁鲁', '1', '杭州', '浙江', '中国', 'zh_CN', 'http://wx.qlogo.cn/mmopen/PiajxSqBRaEI17OBXH1FmzibbXBElnAoog5cuQjctXgOFl71KFQsrIBJdqOJBkUfzglDjsqkvEReKZcZvLa4ibjNQ/0', '1513588527', null, '1', '', '0', '[]', '1'), ('7', 'oSaaIwuf1OXIgwxnv9uN31nBKw6o', null, '贡7', '1', '', '', '捷克共和国', 'zh_CN', 'http://thirdwx.qlogo.cn/mmopen/qGusKyb0IEfRA0Mbtr86tNUsH0Bg6DoibSuiaZ6Ar7W3MOoicx7csrrpOsNMwNlX6wzXGf5KeAmicZh1A4lBl1XgaA/132', '1517808520', null, '1', '', '0', '[]', '1');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
